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/
