Jay,
Here's a suggestion. It looks like you are trying to submit each field as if
all of them were "Text". if you have any number, numeric or Integer field in
your database then you should be leaving off the single quotes ''. it also
might not hurt to check your database structure to ensure that each of the
fields you are entering are indeed the correct data type. e.g. text,
integer, long integer. in particular i would check your FORM.PriceFrame
field, as price usually, but not always, indicates a numeric value in your
database.
best of luck,
nelson
----Original Message Follows----
From: "Jay Patton" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re: HELP!!
Date: Fri, 12 Jan 2001 09:43:26 -0700
Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id
MHotMailBC28A37B00AA40043121CF1F7A8C8F130; Fri Jan 12 11:18:32 2001
Received: from houseoffusion.com ([207.31.122.140]) by
www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID#
0-54969U100L100S0V35) with ESMTP id com for
<[EMAIL PROTECTED]>; Fri, 12 Jan 2001 11:52:11 -0500
>From [EMAIL PROTECTED] Fri Jan 12 11:20:32 2001
Message-id: <005201c07cb6$c9aca1c0$cb01a8c0@feds>
References: <000c01c07cae$f550c980$[EMAIL PROTECTED]>
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists