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.
-----Original Message-----
From: Greg Morphis [mailto:[EMAIL PROTECTED]
Sent: Friday, May 23, 2008 4:37 PM
To: CF-Talk
Subject: Re: Syntax Error In Update Statement
If it's numeric in the DB it should NOT be cf_sql_clob
On Fri, May 23, 2008 at 3:34 PM, morgan l <[EMAIL PROTECTED]> wrote:
> The query you posted (UPDATE HomeCareCompany) is not the query
reporting the
> error ( UPDATE 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# <http://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
>>
>>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:305977
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
