RE: Microsoft Access limitations

[Andy Ousterhout]

The error message says that it can't find your table.  Does it exist in DSN
and if so, are you using any Access User security?

Andy
  -----Original Message-----
  From: Anna Smith [mailto:[EMAIL PROTECTED]
  Sent: Monday, February 23, 2004 3: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]

---