Steve, That only produces a data type mismatch error message.
George ----- Original Message ----- From: "Steve" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, April 04, 2002 5:05 AM Subject: [PHP-DB] Re: Inserting into Access > Try adding single quotes to the user and date fields > > George Pitcher wrote: > > > > 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) > > VALUES > > (6, '15381', 20020403, '146.176.13.99', '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 > > fields. > > > > 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
