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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279241 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
