Not to mention that date is a reserved word.
Shawnea Carter
----- Original Message -----
From: "Dave Watts" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, January 07, 2001 6:02 PM
Subject: RE: insert query problems
> > I keep getting this error message, have racked my brains,
> > doublechecked field names form names and table names but
> > still haven't got a clue as to the problem.
> > ...
> > ODBC Error Code = 37000 (Syntax error or access violation)
> > [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> > statement.
> > SQL = "INSERT INTO tblNews ( OrgID, Date, Subject, Article, Article,
> > DateModified)
> > VALUES (2769, '8/1/2001', 'Heading', 'Article notes', 31,
> > '{ts '2001-01-08 09:49:58'}')"
>
> Looks like double vision. You've got "Article" listed twice in your field
> list, and you're trying to insert a string in the first one and an integer
> in the second.
>
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
