ODBiC Discussion Board

mySQL problem with USER command

by Jon Grosse, April 26, 2007 12:26

I have been using ODBscript with an msAccess database and have decided to move it to mySQL. The mySQL table entries are all datatype VARCHAR(50) and named ISIR_uid, last_access, user_name and user_email.

However, I get the following error message from the line below:


ODBscript Error: User table query failed: DATABASE ERROR: 37000 [MySQL][ODBC 3.51 Driver][mysqld-5.0.27-community-nt] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Now()) AS last_access_min FROM sessions WHERE ISIR_uid='20070426195513-'' at line 1

(The command does however write the following to the sessions table)

ISIR_uid = 20070426202233- last_access = 2007-04-26 20:22:33


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.