OH MY GOD!!!!!!!
i looked this over and over and over and over yesterday. i was getting so
pissed at it i (and the guy in the office next to me) totaly looked that
over. sorry about that. but thanks.
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "Jason Lees (National Express)" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 8:39 AM
Subject: RE: HELP!!
>
> The Reason you get an error with the first option is that you appear to be
a
> data field short. There are 9 defined in the top yet only eight have
values.
>
> Dont know about the second option though, new one to me....
>
> -----Original Message-----
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: 12 January 2001 15:26
> To: CF-Talk
> 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
