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
