; Bobby Hartsfield
> http://acoderslife.com
> http://cf4em.com
>
> -Original Message-
> From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
> Sent: Monday, March 14, 2011 5:41 PM
> To: cf-talk
> Subject: RE: Data Truncation on TEXT field
>
>
> Enable Blo
Even the ones**
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Bobby Hartsfield [mailto:bo...@acoderslife.com]
Sent: Monday, March 14, 2011 5:41 PM
To: cf-talk
Subject: RE: Data Truncation on TEXT field
Enable Blob/Clob
Enable Blob/Clob on the datasoruce.
FYI, this is a public list indexed by Google... Client's can search for your
name... if the ones with no sense haha ;-)
.:.:.:.:.:.:.:.:.:.:.:.:.:.
Bobby Hartsfield
http://acoderslife.com
http://cf4em.com
-Original Message-
From: Robert Harrison [mail
Rob,
The Text, NText, and Image data types come from the previous versions of SQL
Server. It is recommended that you use the newer varchar(MAX),
nvarchar(MAX), and varbinary(MAX) data types instead.
Results to text only allows a maximum of 8192 characters. Perhaps this is
also your issue in quer
lug in to our blog: A&W Unplugged
http://www.austin-williams.com/unplugged
-Original Message-
From: Brian Cain [mailto:bcc9...@gmail.com]
Sent: Monday, March 14, 2011 1:43 PM
To: cf-talk
Subject: Re: Data Truncation on TEXT field
Check the advanced settings on the datasource in the
Going straight to just the SQL update I have:
UPDATE tbl_capabilities_categories
SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS'
WHERE id=#id#;
capability_cat_txt2 field type is TEXT
Only about 63,000 of the update characters are being updated to the field. The
r
Check the advanced settings on the datasource in the CF Adminstrator. Make
sure "CLOB" (Enable long text retrival) is checked , and increase the long
text buffer to handle the larger data field size.
~|
Order the Adobe Coldfusi
7 matches
Mail list logo