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
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:
// 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();
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
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
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
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
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: 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
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 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: 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
