No, order doesn't matter - but back to something you mentioned earlier - the query is within a <cfif> tag? Can you post some of that code? Also, does the error message show the actual data being passed through, such as [SQL = "SELECT userName, password, TotalLogins, LastIP].
That may...
The error means that the symbols (',*," etc) are not understood. It may have to do with the version of odbc driver being used...try the following sql instead:
WHERE strProdName LIKE '%#searchtext#%'
-milleem
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.