thanks for the reply cfstoredproc works with sql2000 fine with the unicode
cfquery approach works - but then can't get multiple result sets back when available, and you can't use queryparam, though a plain insert works fine with queryparam and a ntext column "Taco Fleur" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] Have you tried calling the SP via CFQUERY? Example <cfquery name="." datasource="."> EXEC stored_procedure 'parameter 1', parameter 2 etc. etc. </cfquery> I don't think CFSTORED PROCEDURE can handle Unicode, but not 100% sure about that. -----Original Message----- From: Elliot Russo [mailto:[EMAIL PROTECTED] Sent: Wednesday, 15 October 2003 12:57 PM To: CFAussie Mailing List Subject: [cfaussie] I'm begging now which is unbecoming I know Hi, the following works except the final cfstoredproc which give a 'text to ntext error' trying to input text data -> ntext parameter - > ntext col <cftry> <cfset sString = "بحث �.ت�,د�."> <!--- <cfquery datasource="enabled"> insert into test_ntext (ntText) values ('#sString#') </cfquery> <cfquery datasource="enabled"> insert into test_ntext (ntText) values (N'#sString#') </cfquery> <cfquery > insert into test_ntext (ntText) values (N'بحث �.ت�,د�.') </cfquery> <cfquery > insert into test_ntext (ntText) values (<cfqueryparam value="#sString#" cfsqltype="CF_SQL_LONGVARCHAR" null="NO">) </cfquery> <cfoutput><p>Insert</p></cfoutput> <cfquery name="qResults" datasource="#request.enabled.datasource.dsn#" username="#request.enabled.datasource.db_userid#" password="#request.enabled.datasource.db_password#"> exec testNTEXT N'#sString#' </cfquery> <cfoutput><p>Exec1</p></cfoutput> <cfstoredproc procedure="testNTEXT" > <cfprocparam type="In" value="#sString#" cfsqltype="CF_SQL_LONGVARCHAR" null="No"> <cfprocresult name="qTest" resultset="1"> </cfstoredproc> <cfoutput><p>Sproc</p></cfoutput> <!--- ---> <cfcatch> <cfdump var="#cfcatch#"> </cfcatch> </cftry> -- Regards, Elliot Russo [EMAIL PROTECTED] +61 02 4862 2592 (work/fax) +61 0410 546 996 (mob) --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
