Inserting into Access
| From: | George Pitcher | Date: | Wed, 03 Apr 2002 15:23:48 +0000 |
| Subject: | Inserting into Access | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18166@lists.php.net to get a copy of this message | ||
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