ok so i added the 'type' field back into the statement but i still get that
same error:
( Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement )
<!--
<cfquery name="Image" datasource="????" dbtype="ODBC">
INSERT INTO ImageManager
(ImageName,BigImage,ArtistName,Year,Date,Type,RealName,Size,PriceFrame)
VALUES (
'#Form.ImageName#',
'#Form.BigImage#',
'#Form.ArtistName#',
'#Form.Year#',
'#Form.Date#',
'#Form.Type#',
'#Form.RealName#',
'#Form.Size#',
'#Form.PriceFrame#')
</cfquery>
-->
any other ideas or thougths?
thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
----- Original Message -----
From: "Eric Barr" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 8:47 AM
Subject: RE: HELP!!
> Sure looks like your values are unbalanced ....
>
> "Type" exists in the insert into list, but not in the value list.
>
> -eric
> ------------------------------------------------
> Common sense is genius dressed in its working clothes.
> -- Ralph Waldo Emerson
>
> Eric Barr
> Zeff Design
> (p) 212.714.6390
> (f) 212.580.7181
>
>
> -----Original Message-----
> From: Jay Patton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, January 12, 2001 10:26 AM
> 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
