Just as I got this email.... I had just enabled them. Thanks James!
And Tom also, who gave me the hint to look there! Thanks all, Yves On 5/25/07, James Wolfe <[EMAIL PROTECTED]> wrote: > > >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:279251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
