search problems

[Guest]

I'm building a search page that filters boot titles from the database and comes up in results as linked entries. i used the adobe help instructions and it worked...as long as the value entered was exactly the same as the book title. i need a search page that can come up with entries based on one or two words. (granted they have to be spelled correctly) i'm in cs3. oh and the recordset includes relational tables.

please help.

[bregent]

The basic technique is to parse the search string into seperate words. Then, in your where clause you need to list each word seperately using either the AND or OR operator, depending on how you want the results.

[Guest]

how...exactly does one do that? do i do this to the form...the recordset...both?

[bregent]

You would do that in the server side script. The script will parse the user's input and use it in the sql query. You will need to write the scipt yourself - DW won't do it for you.