One thing to bear in mind with errors thrown in the middle of a query is that the specified line number is not necessarily the problem one - it just means there's an error somewhere in the query.
In this case, somewhere in the query there's an integer parameter that you're trying to insert into an ntext column. My guess is that it's this one: JeopardyExplain = <cfqueryparam value="#Arguments.pJeopardyExplain#" cfsqltype="cf_sql_integer"null="#nJeopardyExplain#"> ....as all the other Explain columns are using cfsqltype="cf_sql_longvarchar". Hope this fixes it. -- Seb Duggan Web & ColdFusion Developer e: [EMAIL PROTECTED] t: 07786 333184 w: http://sebduggan.com > 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 : ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:315804 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
