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