This is driving me crazy!

I have a test database with one record. The following code works fine:
SELECT user_id,
organization,
last_name,
first_name
FROM security

The following fails with ODBC error 07001

SELECT user_id,
organization,
last_name,
first_name
FROM security
WHERE user_id = #CLIENT.userid#

I have put in displays and #CLIENT.userid# contains valid data. user_id is
properly defined and returns valid data on unqualified read. When read is
qualified,it seems to not pass #CLIENT.userid# to ODBC driver or else driver is
ignoring it for some reason.

I get the following error on the above code:

Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = 07001 (Wrong number of parameters)


Too few parameters. Expected 1.

Hint: The cause of this error is usually that your query contains a reference
to a field which does not exist. You should verify that the fields included in
your query exist and that you have specified their names correctly.


The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (10:1) to (10:65).


Date/Time: 03/21/06 14:18:15
Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR
1.1.4322)
Remote Address: 127.0.0.1