(ot) SQL 2000 + FCKEdit truncation problem

2009-02-11 Thread Les Mizzell
SQL Server 2000 (8.0.x) Database field type ntext Using FCKEditor as a rich text editor for this field There's no restriction on size in the insert query. There's no restriction on the amount of stuff that can be typed/pasted into the field. Can anyone come up with a reason why all inserts are

Re: (ot) SQL 2000 + FCKEdit truncation problem

2009-02-11 Thread Jochem van Dieten
On Wed, Feb 11, 2009 at 4:48 PM, Les Mizzell wrote: SQL Server 2000 (8.0.x) Database field type ntext Can anyone come up with a reason why all inserts are truncated after approx 31,000 (give or take) characters? Did you enable CLOB support in the advanced properties of the DSN definition?

RE: (ot) SQL 2000 + FCKEdit truncation problem

2009-02-11 Thread Adrian Lynch
To: cf-talk Subject: (ot) SQL 2000 + FCKEdit truncation problem SQL Server 2000 (8.0.x) Database field type ntext Using FCKEditor as a rich text editor for this field There's no restriction on size in the insert query. There's no restriction on the amount of stuff that can be typed/pasted

Re: (ot) SQL 2000 + FCKEdit truncation problem

2009-02-11 Thread Rick Root
check our Datasource settings make sure enable large text retrieval is ON On Wed, Feb 11, 2009 at 10:48 AM, Les Mizzell lesm...@bellsouth.net wrote: SQL Server 2000 (8.0.x) Database field type ntext Using FCKEditor as a rich text editor for this field There's no restriction on size in the

Re: (ot) SQL 2000 + FCKEdit truncation problem

2009-02-11 Thread John M Bliss
Are you using cfstoredproc or cfquery? If cfquery, can you reply with body of query? On Wed, Feb 11, 2009 at 9:48 AM, Les Mizzell lesm...@bellsouth.net wrote: SQL Server 2000 (8.0.x) Database field type ntext Using FCKEditor as a rich text editor for this field There's no restriction on

Re: (ot) SQL 2000 + FCKEdit truncation problem

2009-02-11 Thread Jason Fisher
Have you checked the Long Text Buffer setting, under Advanced Settings for the Datasource in CF Administrator? Maybe it's at 32000 or something? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to