That only produces a data type mismatch error message.
----- 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, '18.104.22.168', '15:08', 'Counselling')
> > The error is:
> > SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in
> > 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
> > 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