Re: Re: Inserting into Access
| From: | George Pitcher | Date: | Thu, 04 Apr 2002 06:47:18 +0000 |
| Subject: | Re: Re: Inserting into Access | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-18187@lists.php.net to get a copy of this message | ||
Steve,
That only produces a data type mismatch error message.
George
----- Original Message -----
From: "Steve" <stlake@accesswave.ca>
To: <php-db@lists.php.net>
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