Actually, looking at it again. It's not the writing of the data, it's the retrieval, so no actual truncation takes place?
-----Original Message----- From: Jenny Gavin-Wear [mailto:jenn...@fasttrackonline.co.uk] Sent: 18 February 2013 15:28 To: cf-talk Subject: RE: Truncating pages SQL 2000 Hi Rob, Thanks for your reply. I'm getting rusty! I forgot to enable long text retrieval on a new server. Cheers, Jenny -----Original Message----- From: Rob Parkhill [mailto:robert.parkh...@gmail.com] Sent: 18 February 2013 13:49 To: cf-talk Subject: Re: Truncating pages SQL 2000 Jenny, There is a limit on the amount of text that can be written to the database in CF. It's a part of the advanced settings for the database connection. Limit is 65000 characters by default. You can up that to anything. Hope that helps, Rob On 2013-02-18 8:06 AM, "Jenny Gavin-Wear" <jenn...@fasttrackonline.co.uk> wrote: > > Hi all, > > Is there anything that could cause truncation of data in an ntext > field, either by sql or coldfusion, or some other way? > > I have a CMS app that has been running a site for a few years and the > content field of the CMS pages has become truncated. I need to > determine whether this was user error, or if it could have happened in any other way. > > Many thanks, > Jenny > > > -- > I am using the free version of SPAMfighter. > SPAMfighter has removed 8643 of my spam emails to date. > Get the free SPAMfighter here: http://www.spamfighter.com/len > > Do you have a slow PC? Try a Free scan > http://www.spamfighter.com/SLOW-PCfighter?cid=sigen > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:354568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm