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:[email protected]] 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
