Take out the quotes from the first line.
HTH,
Howie
----- Original Message -----
From: "Jay Patton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, April 16, 2001 6:44 PM
Subject: anyone else?!
> does anyone else see anything wrong with this insert statement?
>
> INSERT INTO myWork ('siteTypeID', 'siteUrl', 'siteName',
'siteDescription', 'dateDone', 'sitePicture')
> VALUES (
> #siteTypeId#,
> '#siteUrl#',
> '#siteName#',
> '#siteDescription#',
> '#dateDone#',
> '#sitePicture#')
>
> all fields are text accept for the siteTypeId that is Number, (this is an
access db)
> This is the error:
> ODBC Error Code = S0022 (Column not found)
>
>
> [Microsoft][ODBC Microsoft Access Driver] The INSERT INTO statement
contains the following unknown field name: ''siteTypeID''. Make sure you
have typed the name correctly, and try the operation again.
>
>
>
> The error occurred while processing an element with a general identifier
of (CFQUERY), occupying document position (12:1) to (14:23).
>
> and the column is in the myWork table so what gives?
>
>
> Thanks in advance....
>
> Jay Patton
> Web Design / Application Design
> Web Pro USA
> p. 406.549.3337 ext. 203
> p. 1.888.5WEBPRO ext. 203
> e. [EMAIL PROTECTED]
> url. www.webpro-usa.com
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
