I also seem to reember that there is some kind of restriction on the database drivers that restricts the size of a string that can be returned? I will try to remember how I dealt this though it was a long time ago!
-----Original Message----- From: Andy McShane [mailto:[EMAIL PROTECTED] Sent: 25 May 2007 15:14 To: CF-Talk Subject: RE: MS SQL 2000 and ntext Check this link, I think this is the same as the problem you are having, I had the same thing in the past. http://www.cfcdeveloper.com/index.cfm/2007/1/9/XML-from-SQL -----Original Message----- From: Yves Arsenault [mailto:[EMAIL PROTECTED] Sent: 25 May 2007 15:00 To: CF-Talk Subject: MS SQL 2000 and ntext Hi there, I'm running CF7 and MS SQL 2000 on this project I'm working on. I'm using a simple cfquery to get a row of data. <cfquery datasource="DB" name="Data"> SELECT * FROM datatable WHERE id = 439 </cfquery> Very, very simple query.... Now, one of these fields is of type ntext. It contains xml data. What I'm trying to do is to retrieve the xml data from this field... what seems to happen, is that the xml isn't returned in it's entirety. It's cut off at a certain point. Any ideas? This table is actually used by (and created with) a .NET program my employer purchased, and the data is used in this program without a problem. I know this is slightly vague.... Thanks, -- Yves Arsenault "Love is the only force capable of transforming an enemy into a friend". --Martin Luther King, Jr. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279245 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
