So, the data is fine in the db, but not displaying all of it? What does the variable look like upon retrieval? Is there something odd in the data that it's causing the truncation? On 2013-02-18 10:39 AM, "Jenny Gavin-Wear" <[email protected]> wrote:
> > 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:[email protected]] > 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:[email protected]] > 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" <[email protected]> > 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:354573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
