>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. >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?
You need to enabled CLOBs and BLOBs in the advanced section of the datasource. Open up your CFAdmin web UI. Edit the datasource. Click advanced. You will see two checkboxes (CLOBs and BLOBs). Check them both. Update. Voila. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Macromedia ColdFusion MX7 Upgrade to MX7 & experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
