Location is a number field. When I try changing it to <cfqueryparam value="#FORM.Location#" cfsqltype="CF_SQL_NUMERIC" maxlength="15"> I still get an error.
In fact when I remove the statement entirely I still get the error. -----Original Message----- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Friday, May 23, 2008 4:30 PM To: CF-Talk Subject: Re: Syntax Error In Update Statement Also.. what is location? Do yow know what a CLOB is? That's a HUGE character field.. can that not be a varchar? On Fri, May 23, 2008 at 3:25 PM, <[EMAIL PROTECTED]> wrote: > I actually want that field to be a 0 if no data was entered on the form. > > > -----Original Message----- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Friday, May 23, 2008 4:22 PM > To: CF-Talk > Subject: Re: Syntax Error In Update Statement > > On Fri, May 23, 2008 at 1:14 PM, Patrick Hedgepath > <[EMAIL PROTECTED]> wrote: >> Can anybody see the syntax error that CF8 keeps giving me for this > query? The query was made by DW CS3 and worked until I added a new field > by hand (Location). I can't see any reason it would not work. >> >> , Location=<cfif IsDefined("FORM.Location") AND #FORM.Location# NEQ > ""> >> <cfqueryparam value="#FORM.Location#" cfsqltype="cf_sql_clob" > maxlength="15"> >> <cfelse> >> 0 >> </cfif> > > shouldn't your <cfelse> be an empty string ("") instead of a 0? > > -- > A byte walks into a bar and orders a pint. Bartender asks him "What's > wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I > thought you looked a bit off." > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305972 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
