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