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:305967 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
