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:354565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
