S
s
I have a search field and a database results working fine. But the text field
only successfully finds one word. Anything else added (comma, %, or, etc.)
gets a no records found.
I found some very complicated discussions on this, including using a REPLACE
command but I don't know how to use that or where to place it.
::Code:: is the name of the text form field and it is searching multiple
columns in the table NEWQuickFlash.
My DBR sql is as follows:
fp_sQry="SELECT * FROM NEWQuickFlash WHERE (Code LIKE '%::Code::%' OR
Subject_Account LIKE '%::Code::%' OR QUICKFLASH_Information LIKE
'%::Code::%') ORDER BY Code ASC,Date DESC"
Is there an easy way to accomplish successful searches when a user enters
multiple words in th eabove situation? I can also specify some rules on how
users enter their searches (such as requiring AND, OR , commas, etc.) in the
search box if it will make it easier to code successfully. THANKS!!!!
only successfully finds one word. Anything else added (comma, %, or, etc.)
gets a no records found.
I found some very complicated discussions on this, including using a REPLACE
command but I don't know how to use that or where to place it.
::Code:: is the name of the text form field and it is searching multiple
columns in the table NEWQuickFlash.
My DBR sql is as follows:
fp_sQry="SELECT * FROM NEWQuickFlash WHERE (Code LIKE '%::Code::%' OR
Subject_Account LIKE '%::Code::%' OR QUICKFLASH_Information LIKE
'%::Code::%') ORDER BY Code ASC,Date DESC"
Is there an easy way to accomplish successful searches when a user enters
multiple words in th eabove situation? I can also specify some rules on how
users enter their searches (such as requiring AND, OR , commas, etc.) in the
search box if it will make it easier to code successfully. THANKS!!!!