flash search

ok, ive got a little flash/asp search thing working but its not right, so

is there anyway i can get flash when a search word is entered into a text box to input this into a query in access?

thanks
Slinky

You cant do it direct from Flash and you need a serverside script inbetween such as ASP or PHP.

yea im using asp


but do i have to do a bit of sql in the asp script, (not ideal) you know, select from bla bla

or

can i do a query inside access that sorts the data from flash by a inputted variable?

u know, e.g. say i want to search by a persons surname, can i input a variable inside flash, pass it through asp so that it inputs it into the criteria in a query inside access?

its just because im writing out the data from access on a asp page then flash is picking them up and displaying it. it'll be ideal if I get the query to work from inside access instead of doing it in asp with a bit of sql stuff