Re: Data Truncation on TEXT field

2011-03-15 Thread Russ Michaels
** .:.:.:.:.:.:.:.:.:.:.:.:.:. 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 on the datasoruce. FYI, this is a public

Data Truncation on TEXT field

2011-03-14 Thread Robert Harrison
Hi, I have a client with no sense who want to type a book into a single field. They have over 200,000 characters they are typing into the edit file. Data base is: MS SQL 2008 R2 Field type is: text When an update is done the data is truncated at around 63,000 characters.

Re: Data Truncation on TEXT field

2011-03-14 Thread Brian Cain
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

RE: Data Truncation on TEXT field

2011-03-14 Thread Robert Harrison
Going straight to just the SQL update I have: cfquery datasource=#dsn# UPDATE tbl_capabilities_categories SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS' WHERE id=#id#; /cfquery capability_cat_txt2 field type is TEXT Only about 63,000 of the update characters are

RE: Data Truncation on TEXT field

2011-03-14 Thread Robert Harrison
: AW 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 CF Adminstrator. Make

Re: Data Truncation on TEXT field

2011-03-14 Thread Russ Michaels
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

RE: Data Truncation on TEXT field

2011-03-14 Thread Bobby Hartsfield
[mailto:rob...@austin-williams.com] Sent: Monday, March 14, 2011 1:39 PM To: cf-talk Subject: Data Truncation on TEXT field Hi, I have a client with no sense who want to type a book into a single field. They have over 200,000 characters they are typing into the edit file. Data base

RE: Data Truncation on TEXT field

2011-03-14 Thread Bobby Hartsfield
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