form post getting cut off at 32,000
Hey all, Bizarre. I have a message board application and a new user is posting 130,000 character long newsletter-like posts that are getting cut off at 31,999 characters in the database, but not in the email that is sent after the sql insert. o There are only two text fields being posted in the form, one is a title (only 50 chars or so) and the other is called form.message coming from a textarea. I'm not using a wysiwyg editor. o The db field message is an ntext of size 2,147,483,646, which should be enough. o The CF Admin setting Maximum size of post data is set to 100 MB o I'm using this to insert the form data: cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#form.message# o While debugging I added the maxlength attribute and set it to 99. No change. o I'm using SQL Server and CF8 o The email that is generated after the insert contains the whole text, so the stripping must not be happening in the form post, but in the database insert itself. What am I missing here? Thanks, Mik Michael Muller Admin, MontagueMA.net Website office (413) 863-6455 mobile (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form post getting cut off at 32,000
My guess is you need to go change the buffer size in the DSN settings in the CF Admin. cheers, barneyb On Thu, Feb 12, 2009 at 11:07 AM, Mik Muller ad...@montaguema.net wrote: Hey all, Bizarre. I have a message board application and a new user is posting 130,000 character long newsletter-like posts that are getting cut off at 31,999 characters in the database, but not in the email that is sent after the sql insert. o There are only two text fields being posted in the form, one is a title (only 50 chars or so) and the other is called form.message coming from a textarea. I'm not using a wysiwyg editor. o The db field message is an ntext of size 2,147,483,646, which should be enough. o The CF Admin setting Maximum size of post data is set to 100 MB o I'm using this to insert the form data: cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#form.message# o While debugging I added the maxlength attribute and set it to 99. No change. o I'm using SQL Server and CF8 o The email that is generated after the insert contains the whole text, so the stripping must not be happening in the form post, but in the database insert itself. What am I missing here? Thanks, Mik Michael Muller Admin, MontagueMA.net Website office (413) 863-6455 mobile (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319245 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: form post getting cut off at 32,000
what's the setting for Long Text Buffer in Advanced Settings for your dsn in cf admin? do you have clob/blob retrieval enabled there as well? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mik Muller wrote: Hey all, Bizarre. I have a message board application and a new user is posting 130,000 character long newsletter-like posts that are getting cut off at 31,999 characters in the database, but not in the email that is sent after the sql insert. o There are only two text fields being posted in the form, one is a title (only 50 chars or so) and the other is called form.message coming from a textarea. I'm not using a wysiwyg editor. o The db field message is an ntext of size 2,147,483,646, which should be enough. o The CF Admin setting Maximum size of post data is set to 100 MB o I'm using this to insert the form data: cfqueryparam cfsqltype=CF_SQL_LONGVARCHAR value=#form.message# o While debugging I added the maxlength attribute and set it to 99. No change. o I'm using SQL Server and CF8 o The email that is generated after the insert contains the whole text, so the stripping must not be happening in the form post, but in the database insert itself. What am I missing here? Thanks, Mik Michael Muller Admin, MontagueMA.net Website office (413) 863-6455 mobile (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form post getting cut off at 32,000
Yeah... this just bit me too. You need to adjust either your clob/blob size for the DSN. The default cuts off at 32k. Even if the clob/blob options are not checked, that seems to be the cutoff. I'm reasonably sure that clob is the one you're looking to change. Matthew Williams Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319249 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: form post getting cut off at 32,000
Yes, that was it. I had Long Text Buffer (chr) set to 64000 and the CLOB checkbox off. I suppose that the field being ntext cut the 64000 in half to 32000. Perhaps I should change the field to just text. Now to update a few dozen databases. Sigh. Anyone know how to script that kind of change? Is that even possible? Thanks to everyone for writing back. Mik At 02:42 PM 2/12/2009, Matthew Williams wrote: Yeah... this just bit me too. You need to adjust either your clob/blob size for the DSN. The default cuts off at 32k. Even if the clob/blob options are not checked, that seems to be the cutoff. I'm reasonably sure that clob is the one you're looking to change. Matthew Williams Geodesic GraFX Michael Muller Admin, MontagueMA.net Website office (413) 863-6455 mobile (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319251 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: form post getting cut off at 32,000
Sure, it's scriptable. Google sql alter table and the particular platform of DB you are using. Thanks, Mike -Original Message- From: Mik Muller [mailto:ad...@montaguema.net] Sent: Thursday, February 12, 2009 2:08 PM To: cf-talk Subject: Re: form post getting cut off at 32,000 Yes, that was it. I had Long Text Buffer (chr) set to 64000 and the CLOB checkbox off. I suppose that the field being ntext cut the 64000 in half to 32000. Perhaps I should change the field to just text. Now to update a few dozen databases. Sigh. Anyone know how to script that kind of change? Is that even possible? Thanks to everyone for writing back. Mik At 02:42 PM 2/12/2009, Matthew Williams wrote: Yeah... this just bit me too. You need to adjust either your clob/blob size for the DSN. The default cuts off at 32k. Even if the clob/blob options are not checked, that seems to be the cutoff. I'm reasonably sure that clob is the one you're looking to change. Matthew Williams Geodesic GraFX Michael Muller Admin, MontagueMA.net Website office (413) 863-6455 mobile (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319252 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: form post getting cut off at 32,000
I thought this was the DSN being changed, not the database itself. I was thinking this would be a cf adminObj thing, like this code I use to create the DBs now: cfscript // Login is always required. This example uses two lines of code. adminObj = createObject(component,cfide.adminapi.administrator); adminObj.login(#request.app.cfadmin#); // Instantiate the data source object. dbObj = createObject(component,cfide.adminapi.datasource); // Create a DSN. dbObj.setMSSQL( driver=MSSQLServer, name=#theDBName#, host = localhost, port = 1433, selectmethod = cursor, database = #theDBName#, username = #theUName#, password = #thePWord# ); adminObj.logout(); /cfscript I have already updated all the existing databases. Now I want to make sure all future databases created with this script have the right settings. Mik At 03:43 PM 2/12/2009, you wrote: Sure, it's scriptable. Google sql alter table and the particular platform of DB you are using. Thanks, Mike -Original Message- From: Mik Muller [mailto:ad...@montaguema.net] Sent: Thursday, February 12, 2009 2:08 PM To: cf-talk Subject: Re: form post getting cut off at 32,000 Yes, that was it. I had Long Text Buffer (chr) set to 64000 and the CLOB checkbox off. I suppose that the field being ntext cut the 64000 in half to 32000. Perhaps I should change the field to just text. Now to update a few dozen databases. Sigh. Anyone know how to script that kind of change? Is that even possible? Thanks to everyone for writing back. Mik At 02:42 PM 2/12/2009, Matthew Williams wrote: Yeah... this just bit me too. You need to adjust either your clob/blob size for the DSN. The default cuts off at 32k. Even if the clob/blob options are not checked, that seems to be the cutoff. I'm reasonably sure that clob is the one you're looking to change. Matthew Williams Geodesic GraFX Michael Muller Admin, MontagueMA.net Website office (413) 863-6455 mobile (413) 320-5336 skype: michaelBmuller http://www.MontagueMA.net Eschew Obfuscation ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319253 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: form post getting cut off at 32,000
A bit OT, but I would strongly recommend NOT changing to text. If you ever have an entry expecting a Unicode character outside of the low/high ASCII (0-255 character entries), text will foobar it for you but ntext will handle correctly. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
