Microsoft Access limitations

[Anna Smith]

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]

---