Wasn't quite what I was looking for.... although, this will certainly be VERY useful!
Thanks Andy! Yves On 5/25/07, Andy McShane <[EMAIL PROTECTED]> wrote: > > 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. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:279250 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
