not being able to programmatically delete a view). It should have no trouble
with that query. Have you tried running it from within Access?
-----Original Message-----
From: Anna Smith [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 24 February 2004 9:58 a.m.
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]
