Shot in the dark here, but try this as your insert statement:
INSERT INTO OtherImages (SmallImage, ArtistID, TypeID, ArtName, Price, Size, Date)
VALUES ('#fileName#', #ArtistID#, #TypeID#, '#RealName#', '#Price#', '#Size#',
###Date###)
hth,
Brian Simmons
[EMAIL PROTECTED]
ColdFusion 4.5 Certification testing tool, CF_Buster:
http://www.centrasoft.com
---------- Original Message ----------------------------------
From: "Jay Patton" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date: Wed, 11 Apr 2001 13:32:50 -0600
>....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.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
