sql 7 is the problem - sqlsvr3.50
"Mark M" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > 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/
