CF Long Text Truncation
Discussed this once before, but my client has again exceeded the limits and I'm not sure where the data is being truncated. I am using the settings below. Any ideas what could be causing data truncation on long (extremely long) strings? Data Base = MS SQL Server 2008 R2 Data Field Length = Varchar(MAX) Input field type =textarea Insert Statement CFQUERY Param = cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#trim(secured_text1) # CF Data Source Advanced Settings = -- Enable long text retrieval (CLOB) is Checked Two questions: 1. Is there any place else I should check that may have a setting that's causing data truncation? 2. Is it possible the CFQUERYPARAM type CF_SQL_LONGVARCHAR is causing the truncation. I see I could also use cfsqltype=CF_SQL_CLOB, but that does not seem to be supported on MS SQL Server. Any thoughts as to where the truncation may be occurring? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351911 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Long Text Truncation
the row limit is 8060 bytes, are you sure your not exceeding this ? If you need to exceed this and store large amount of data thent hose fields will need to use TEXT or nTEXT data type which is not constained by the row limit as the data stored in these is treated as a BLOB, and the DB simply stores a pointer tot he data rather then the data itself in the table row. On Tue, Jul 17, 2012 at 2:49 PM, Robert Harrison rob...@austin-williams.com wrote: Discussed this once before, but my client has again exceeded the limits and I'm not sure where the data is being truncated. I am using the settings below. Any ideas what could be causing data truncation on long (extremely long) strings? Data Base = MS SQL Server 2008 R2 Data Field Length = Varchar(MAX) Input field type =textarea Insert Statement CFQUERY Param = cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#trim(secured_text1) # CF Data Source Advanced Settings = -- Enable long text retrieval (CLOB) is Checked Two questions: 1. Is there any place else I should check that may have a setting that's causing data truncation? 2. Is it possible the CFQUERYPARAM type CF_SQL_LONGVARCHAR is causing the truncation. I see I could also use cfsqltype=CF_SQL_CLOB, but that does not seem to be supported on MS SQL Server. Any thoughts as to where the truncation may be occurring? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351912 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Long Text Truncation
Russ, the use of Varchar(MAX) negates that 8060 limit. SQL Server stores it differently. That being said, Robert, are you sure that all the data is getting to your query? You say that they are doing extremely large entries, are you hitting the HTML Post limit? I believe that most web servers default the max size of a form post to 2 megabytes. Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, July 17, 2012 10:14 AM To: cf-talk Subject: Re: CF Long Text Truncation the row limit is 8060 bytes, are you sure your not exceeding this ? If you need to exceed this and store large amount of data thent hose fields will need to use TEXT or nTEXT data type which is not constained by the row limit as the data stored in these is treated as a BLOB, and the DB simply stores a pointer tot he data rather then the data itself in the table row. On Tue, Jul 17, 2012 at 2:49 PM, Robert Harrison rob...@austin-williams.com wrote: Discussed this once before, but my client has again exceeded the limits and I'm not sure where the data is being truncated. I am using the settings below. Any ideas what could be causing data truncation on long (extremely long) strings? Data Base = MS SQL Server 2008 R2 Data Field Length = Varchar(MAX) Input field type =textarea Insert Statement CFQUERY Param = cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#trim(secured_text1) # CF Data Source Advanced Settings = -- Enable long text retrieval (CLOB) is Checked Two questions: 1. Is there any place else I should check that may have a setting that's causing data truncation? 2. Is it possible the CFQUERYPARAM type CF_SQL_LONGVARCHAR is causing the truncation. I see I could also use cfsqltype=CF_SQL_CLOB, but that does not seem to be supported on MS SQL Server. Any thoughts as to where the truncation may be occurring? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351913 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Long Text Truncation
ah yes Varchar (max) is the new TEXT On Tue, Jul 17, 2012 at 3:20 PM, DURETTE, STEVEN J sd1...@att.com wrote: Russ, the use of Varchar(MAX) negates that 8060 limit. SQL Server stores it differently. That being said, Robert, are you sure that all the data is getting to your query? You say that they are doing extremely large entries, are you hitting the HTML Post limit? I believe that most web servers default the max size of a form post to 2 megabytes. Steve -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Tuesday, July 17, 2012 10:14 AM To: cf-talk Subject: Re: CF Long Text Truncation the row limit is 8060 bytes, are you sure your not exceeding this ? If you need to exceed this and store large amount of data thent hose fields will need to use TEXT or nTEXT data type which is not constained by the row limit as the data stored in these is treated as a BLOB, and the DB simply stores a pointer tot he data rather then the data itself in the table row. On Tue, Jul 17, 2012 at 2:49 PM, Robert Harrison rob...@austin-williams.com wrote: Discussed this once before, but my client has again exceeded the limits and I'm not sure where the data is being truncated. I am using the settings below. Any ideas what could be causing data truncation on long (extremely long) strings? Data Base = MS SQL Server 2008 R2 Data Field Length = Varchar(MAX) Input field type =textarea Insert Statement CFQUERY Param = cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#trim(secured_text1) # CF Data Source Advanced Settings = -- Enable long text retrieval (CLOB) is Checked Two questions: 1. Is there any place else I should check that may have a setting that's causing data truncation? 2. Is it possible the CFQUERYPARAM type CF_SQL_LONGVARCHAR is causing the truncation. I see I could also use cfsqltype=CF_SQL_CLOB, but that does not seem to be supported on MS SQL Server. Any thoughts as to where the truncation may be occurring? Thanks Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351914 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Long Text Truncation
are you sure that all the data is getting to your query ... are you hitting the HTML Post limit Where is this setting? Is this an IIS setting or something? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Long Text Truncation
Don't know if this will help but try looking at this: http://cutesoft.net/forums/thread/42292.aspx It's for IIS7 but it was quickly googled, so it may be a start. Before going that way though I would test. Submit one of these long posts to a test page and determine if what you sent is what got through. If its not then look at IIS. Steve -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, July 17, 2012 11:14 AM To: cf-talk Subject: RE: CF Long Text Truncation are you sure that all the data is getting to your query ... are you hitting the HTML Post limit Where is this setting? Is this an IIS setting or something? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351916 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Long Text Truncation
Don't forget you need the Enable long text retrieval (CLOB). checkbox checked within the cfadmin datasource settings. (its under advanced settings...) Brook -Original Message- From: DURETTE, STEVEN J [mailto:sd1...@att.com] Sent: July-17-12 8:35 AM To: cf-talk Subject: RE: CF Long Text Truncation Don't know if this will help but try looking at this: http://cutesoft.net/forums/thread/42292.aspx It's for IIS7 but it was quickly googled, so it may be a start. Before going that way though I would test. Submit one of these long posts to a test page and determine if what you sent is what got through. If its not then look at IIS. Steve -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, July 17, 2012 11:14 AM To: cf-talk Subject: RE: CF Long Text Truncation are you sure that all the data is getting to your query ... are you hitting the HTML Post limit Where is this setting? Is this an IIS setting or something? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_ ~| 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:351917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
