Replies Back to Article

If you want to search more that one field of the database then add a '+' in the Search Column line eg:

SearchColumn = "Name + Description"

I can't seem to get it to accept more than one word. One word or partial words are fine, but it freaks on a space. I get

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'keywords + shirtname + description + statename LIKE '%FIRSTSEARCHEDWORD%' keywords + shirtname + description + statename LIKE '%SECONDSEARCHEDWORD%''.

/freeform.asp, line49

The colored words represent the 2 words in a search string. I've customized the script some, but as I said, the single and partial word search work fine. Any ideas?

EX: SearchColumn = "Name & Description"

Have anyone tried out Searching Multiple Columns on MYSQL Database ?

With one column works just fine, but not ;,&+ is not working as separator for the columns

Thanx

I've done everything by the book but i still dont get a filtered result, i get all the records instead. i am using mySQL, could it be a SQL syntax difference ? and if it is
can someone tell me what it might be.