it is and i overlooked that,
thanks,
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
----- Original Message -----
From: "Garza, Jeff" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, April 11, 2001 2:00 PM
Subject: RE: insert help
> I think that Date is a reserved word... Try changing that to myDate or
> something else.
>
> Jeff Garza
> Web Developer/Webmaster
> Spectrum Astro, Inc.
> 480.892.8200
>
> [EMAIL PROTECTED]
> http://www.spectrumastro.com
>
>
>
> -----Original Message-----
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 12:33 PM
> To: CF-Talk
> Subject: insert help
>
>
> .....quick question...
>
> does anyone see anything wrong w/ this insert statement?
>
> <cfset fileName = File.ServerFile>
> <cfset ArtistID = Form.ArtistID>
> <cfset TypeID = Form.TypeID>
> <cfset ArtName = Form.RealName>
> <cfset Price = Form.PriceFrame>
> <cfset Date = Form.Date>
>
> <cfquery name="AddImage"
> datasource="catlingalleries"
> dbtype="ODBC">
> INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price,
Size,
> Date)
> VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#',
> '#Size#', '#Date#')
> </cfquery>
>
>
> this is the error i get:
>
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
>
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
>
>
>
> The error occurred while processing an element with a general identifier
of
> (CFQUERY), occupying document position (41:1) to (43:23).
>
>
> Date/Time: 04/11/01 13:29:49
> Browser: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 5.0)
>
>
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
