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

Reply via email to