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:319244 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
