Subject: RE: Truncating pages SQL 2000
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 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
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
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
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
. 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
6 matches
Mail list logo
