Invalid use of '.', '!', or '()'. in query expression
Posted on 2002-06-26
Hello and thanks in advance. I'm performing a very basic query where I'm checking a value against my db. I'm performing the following query:
<cfquery name="usercode_entry" datasource="#request.db#">
WHERE Usercode = '#Trim(FORM.Usercode)#'
Some of the usercodes are formatted as such --> A.60203. I get the following error when a value such as the one above is input...
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Invalid use of '.', '!', or '()'. in query expression 'Usercode = A.60203'.
The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (27:1) to (27:57).
This should be easy stuff but I'm genuinely stumped.