It is a number field in an Access DB. Below is the entire query.
<cfif IsDefined("FORM.MM_UpdateRecord") AND FORM.MM_UpdateRecord EQ
"form1">
<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_NUMERIC"
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>
-----Original Message-----
From: Charlie Griefer [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 5:06 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
On Fri, May 23, 2008 at 1:58 PM, <[EMAIL PROTECTED]> wrote:
> When I change it to CF_SQL_NUMERIC the error persists. Even if I
remove
> the entire statement
>
> , Location=<cfif IsDefined("FORM.Location") AND #FORM.Location# NEQ
"">
> <cfqueryparam value="#FORM.Location#" cfsqltype="CF_SQL_NUMERIC"
> maxlength="15">
> <cfelse>
> 0
> </cfif>
>
> The error still persists.
is it numeric or is it integer?
if the error persists without that line, can you paste the query as
you currently have it?
--
A byte walks into a bar and orders a pint. Bartender asks him "What's
wrong?" Byte says "Parity error." Bartender nods and says "Yeah, I
thought you looked a bit off."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305979
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
