I ran into something similar a week or so ago, don't know if this will work for your issue, but instead of SELECT *, try selecting the specific fields you need and put the ntext field as the very last in your select statement. Maybe maybe not <shrug>
Bob >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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
