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 "999999". 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
