Hi all,

I'm having a problem inserting some php stuff into an Access table.

 This is what is being sent to Access:

 INSERT INTO ActivityLog (User, Docid, Date, ClientIP, Time, CourseRef)
 (6, '15381', 20020403, '', '15:08', 'Counselling')

 The error is:

 SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT
 INTO statement., SQL state 37000

 In explanation, User and Date are Number fields and the rest are text

 I am using a similar syntax INSERT INTO another table in the same database
without a problem. Possibly a cursor problem (I remember some, but not
enough, stuff from my brief flirtation with ASP).

 Any clues?????

 George in Edinburgh

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to