Hi Jay,
Date is a reserverd word in SQL. Change your column name.
Aaron Johnson, MCSE, MCP+I
Allaire Certified ColdFusion Developer
MINDSEYE, Inc.
<phn>617.350.0339
<fax>617.350.8884
<icq>66172567
[EMAIL PROTECTED]
> -----Original Message-----
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 3: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
