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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279243 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
