Your insert statement still contains the field TYPE. Remove that to correct
the syntax error.
Bob.
----- Original Message -----
From: "Jay Patton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 9:26 AM
Subject: HELP!!
> i am having problems getting this statement to write to the db
properly.... all of the fields enter the way they should accept the
ImageName which is a file upload..
> it shows up in the db as C:\windows\temp... ect...
> it worked a few days ago and i took one form field out of the statement
and the form its self and now i cant get it to work again... so here is the
code (both that i have tried to use in the last 2 hours)
> <!--
>
> <cfquery name="Image" datasource="????" dbtype="ODBC">
> INSERT INTO ImageManager (ImageName, BigImage, ArtistName, Year, Date,
Type, RealName, Size, PriceFrame)
> VALUES
> '#ImageName#',
> '#form.BigImage#',
> '#form.ArtistName#',
> '#form.Year#',
> '#form.Date#',
> '#form.RealName#',
> '#form.Size#',
> '#form.PriceFrame#')
> </cfquery>
> -->
> With this i get a syntax error on my INSERT INTO
>
> and then.....
> <!--
>
> <cfset ImageName = Form.ImageName>
> <cfinsert datasource="????"
> tablename="ImageManager"
> dbtype="ODBC"
> formfields="ImageName, BigImage, ArtistName, Year, Date, Type,
RealName, Size, PriceFrame">
> -->
> with this everything goes fine accept it enters the
C:\WINNT\TEMP\ACF2F19.tmp (or something like it) in the ImageName field of
the db.
> has anyone else had this problem or can anyone PLEASE help me? (oh yeah
the file uploads fine just enters the wrong info into the db.)
>
> many thanks,
>
> Jay Patton
> Web Pro USA
> 406.549.3337 ext. 203
> 1.888.5WEBPRO
> 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
