|
|
Home / Groups / ColdFusion Talk (CF-Talk)
sql param errorError 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: sastew01@email.unc.edu |
Mailing Lists
|
Latest Fusion Authority Articles
|
