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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists