Is this the same query? The query you posted was using a different table <cfquery datasource="#DSN#" name="UpdateCompany"> UPDATE HomeCareCompany SET Active=<cfif IsDefined("FORM.Active")>
The query below uses "Physician" On Fri, May 23, 2008 at 3:28 PM, <[EMAIL PROTECTED]> wrote: > One that is not very helpful :( > > Error Executing Database Query. > Syntax error in UPDATE statement. > > The error occurred in > C:\users\respiratorydiagnosticsllc.com\www\admin\EditPhysician.cfm: line > 71 > > 69 : '' > 70 : </cfif> > 71 : WHERE ID=<cfqueryparam value="#FORM.ID#" > cfsqltype="cf_sql_numeric"> > 72 : </cfquery> > 73 : <cflocation url="main.cfm"> > > SQLSTATE > SQL UPDATE Physician SET Active= 1 , NPI= (param 1) , FirstName= > (param 2) , LastName= (param 3) , Suffix= (param 4) , Email= (param 5) , > Password= (param 6) , Address= (param 7) , City= (param 8) , "State"= > (param 9) , Zip= (param 10) , Phone= (param 11) , Fax= '' WHERE ID= > (param 12) > VENDORERRORCODE 3092 > > > > -----Original Message----- > From: Greg Morphis [mailto:[EMAIL PROTECTED] > Sent: Friday, May 23, 2008 4:25 PM > To: CF-Talk > Subject: Re: Syntax Error In Update Statement > > What error does CF give? > > On Fri, May 23, 2008 at 3: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. >> >> <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_clob" > 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> >> >> > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:305971 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4