(tb_user_info) is correct?
Jevo
-----Original Message-----
From: Anna Smith [mailto:[EMAIL PROTECTED]
Sent: Monday, February 23, 2004 1:58 PM
To: CF-Talk
Subject: Microsoft Access limitations
I'm trying to use the "IN" operator in a where clause and I keep getting the
following error:
**********
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
SQL = "SELECT * FROM tb_user_info WHERE accountCreateID IN
('user100','user48076') ORDER BY lastName, firstName"
************
I'm thinking that this is Access's problem, not ColdFusion. Has anyone seen
this before? Any suggestions? Thanks.
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
