Elliot -
Unless i missed it -
What DB?
What Drivers you using to connect?
Mark
------------------------------------------------------------------
[EMAIL PROTECTED]
ICQ: 3094740
Safe From Bees
[ www.safefrombees.com ]
Quoting Elliot Russo <[EMAIL PROTECTED]>:
> 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/
