keyword searching

[pepps]

hi can anybody tell me how to create a search form on my database where a user would only have to type the first few letters of a paticular product and it woulld return results

thanks

john

[Nathon Jones]

Hi John,

Your SELECT statement, on your results page, should read something like:

SELECT * FROM table WHERE productname LIKE 'varSearch%'

varSearch % Request.Form("nameofyoursearchformfield")

Can't remember if your form should have a POST or GET method. Try both!

Hope this helps.
Nath.


"pepps" <webforumsuser@macromedia.com> wrote in message
news:d46bc2$4t7$1@forums.macromedia.com...

> hi can anybody tell me how to create a search form on my database where a
> user would only have to type the first few letters of a paticular product
> and it woulld return results
>
> thanks
>
> john