Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by milleem
-
Query with variable throwing errors.
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... -
Query with variable throwing errors.
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
