Well first off this was code generated by Dream Weaver using the testing server environment so yell at Adobe. Can I write it from scratch myself sure but I was trying to save time. All it appears to have done is waste time. Why would this give you a heart attack. This query was working until I added the additional field like I mentioned earlier. Then even removing the field does not help now.
-----Original Message----- From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Friday, May 23, 2008 5:26 PM To: CF-Talk Subject: Re: Syntax Error In Update Statement Holy F****!?!?!?! .. surely you don't have the password, phone number, fax number, email and company name. I think this email just gave every DB person on this list a heart attack. Clob is for storing GIGS!!!!!!!! of data. Those are varchar's if not numeric.. Fix your query first and then let us know if you still have problems. On Fri, May 23, 2008 at 4:18 PM, <[EMAIL PROTECTED]> wrote: > It is a number field in an Access DB. Below is the entire query. > > <cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ > "form1"> > <cfquery datasource="#DSN#" name="UpdateCompany"> > UPDATE HomeCareCompany > SET Active=<cfif IsDefined("FORM.Active")> > 1 > <cfelse> > 0 > </cfif> > , Location=<cfif IsDefined("FORM.Location") AND #FORM.Location# NEQ ""> > <cfqueryparam value="#FORM.Location#" cfsqltype="CF_SQL_NUMERIC" > maxlength="15"> > <cfelse> > 0 > </cfif> > , CompanyName=<cfif IsDefined("FORM.CompanyName") AND #FORM.CompanyName# > NEQ ""> > <cfqueryparam value="#FORM.CompanyName#" cfsqltype="cf_sql_clob" > maxlength="85"> > <cfelse> > '' > </cfif> > , Email=<cfif IsDefined("FORM.Email") AND #FORM.Email# NEQ ""> > <cfqueryparam value="#FORM.Email#" cfsqltype="cf_sql_clob" > maxlength="75"> > <cfelse> > '' > </cfif> > , Password=<cfif IsDefined("FORM.Password") AND #FORM.Password# NEQ ""> > <cfqueryparam value="#FORM.Password#" cfsqltype="cf_sql_clob" > maxlength="15"> > <cfelse> > '' > </cfif> > , FirstName=<cfif IsDefined("FORM.FirstName") AND #FORM.FirstName# NEQ > ""> > <cfqueryparam value="#FORM.FirstName#" cfsqltype="cf_sql_clob" > maxlength="40"> > <cfelse> > '' > </cfif> > , LastName=<cfif IsDefined("FORM.LastName") AND #FORM.LastName# NEQ ""> > <cfqueryparam value="#FORM.LastName#" cfsqltype="cf_sql_clob" > maxlength="40"> > <cfelse> > '' > </cfif> > , Address=<cfif IsDefined("FORM.Address") AND #FORM.Address# NEQ ""> > <cfqueryparam value="#FORM.Address#" cfsqltype="cf_sql_clob" > maxlength="200"> > <cfelse> > '' > </cfif> > , City=<cfif IsDefined("FORM.City") AND #FORM.City# NEQ ""> > <cfqueryparam value="#FORM.City#" cfsqltype="cf_sql_clob" > maxlength="85"> > <cfelse> > '' > </cfif> > , "State"=<cfif IsDefined("FORM.State") AND #FORM.State# NEQ ""> > <cfqueryparam value="#FORM.State#" cfsqltype="cf_sql_clob" > maxlength="2"> > <cfelse> > '' > </cfif> > , Zip=<cfif IsDefined("FORM.Zip") AND #FORM.Zip# NEQ ""> > <cfqueryparam value="#FORM.Zip#" cfsqltype="cf_sql_clob" maxlength="10"> > <cfelse> > '' > </cfif> > , Phone=<cfif IsDefined("FORM.Phone") AND #FORM.Phone# NEQ ""> > <cfqueryparam value="#FORM.Phone#" cfsqltype="cf_sql_clob" > maxlength="15"> > <cfelse> > '' > </cfif> > , Fax=<cfif IsDefined("FORM.Fax") AND #FORM.Fax# NEQ ""> > <cfqueryparam value="#FORM.Fax#" cfsqltype="cf_sql_clob" maxlength="15"> > <cfelse> > '' > </cfif> > WHERE ID=<cfqueryparam value="#FORM.ID#" cfsqltype="cf_sql_numeric"> > </cfquery> > > > > -----Original Message----- > From: Charlie Griefer [mailto:[EMAIL PROTECTED] > Sent: Friday, May 23, 2008 5:06 PM > To: CF-Talk > Subject: Re: Syntax Error In Update Statement > > On Fri, May 23, 2008 at 1:58 PM, <[EMAIL PROTECTED]> wrote: >> When I change it to CF_SQL_NUMERIC the error persists. Even if I > remove >> the entire statement >> >> , Location=<cfif IsDefined("FORM.Location") AND #FORM.Location# NEQ > ""> >> <cfqueryparam value="#FORM.Location#" cfsqltype="CF_SQL_NUMERIC" >> maxlength="15"> >> <cfelse> >> 0 >> </cfif> >> >> The error still persists. > > is it numeric or is it integer? > > if the error persists without that line, can you paste the query as > you currently have it? > > -- > 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:305996 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
