Error Executing Database Query.
[Macromedia][SQLServer JDBC Driver][SQLServer]Operand type clash: int is
incompatible with ntext
The error occurred in
*C:\htdocs\irb\functions\_functions_protocol_events.cfc: line 491*
*Called from* C:\htdocs\irb\proc\validate_irb_event_form3.cfm: line 258
*Called from* C:\htdocs\irb\proc\validate_irb_event_form3.cfm: line 1
*Called from* C:\htdocs\irb\functions\_functions_protocol_events.cfc:
line 491
*Called from* C:\htdocs\irb\proc\validate_irb_event_form3.cfm: line 258
*Called from* C:\htdocs\irb\proc\validate_irb_event_form3.cfm: line 1
489 : Corrective_Explain = <cfqueryparam
value="#Arguments.pCorrectiveExplain#" cfsqltype="cf_sql_longvarchar"
null="#nCorrectiveExplain#">
490 :
*491 : where Info_Id = <cfqueryparam value="#Arguments.pInfoId#"
cfsqltype="cf_sql_integer">*
492 : </cfquery>
493 :
This is happening in a query contained in a function.
The function is here: http://cfm.pastebin.com/m2c76bb90
(note: I'm debugging somone else's code)
I've dumped the arguments and form scope and it's what I expect for Info_id...
I'm at a loss..
--
Scott Stewart
ColdFusion Developer
Office of Research Information Systems
Research & Economic Development
University of North Carolina at Chapel Hill
Phone:(919)843-2408
Fax: (919)962-3600
Email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:315781
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
