Skip to main content
A
Anonymous
November 16, 2009
Question

search problems

  • November 16, 2009
  • 1 reply
  • 363 views

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.

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
November 16, 2009

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.

A
Anonymous
November 16, 2009

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

B
bregent
Participating Frequently
November 16, 2009

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices