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:

USER TABLE=sessions, TAG=ISIR;

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-10.0.0.6'' at line 1

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

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


Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


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