There's a post limit in the CF admin, I think the default is 100Mb but given that your post is so huge you might want to see if increasing that setting helps.
> -----Original Message----- > From: Robert Harrison [mailto:[email protected]] > Sent: 13 June 2012 17:17 > To: cf-talk > Subject: Date Truncation on CFquery Update > > > I have a client who is essentially entering a document of 50+ pages into a text > area field (tiny MCE). The data is being saved to a data base via CFquery > Update. The data base is MS SQL server and the field length is set to > VARCHAR(MAX). Data is being truncated on update to data base (same place > every time). > > I have checked and the data is not being lost by the text area. If I display the > post field after the Update Query, all the data is there. It's definitely being > truncated either by CFQuery or by the data base. > > I have (temporarily) removed cfqueryparam, so that is not the culprit. > > Any ideas what is causing the truncation? > > Thanks > > > > Robert Harrison > Director of Interactive Services > > Austin & Williams > Advertising I Branding I Digital I Direct > 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X > 119 F 631.434.7022 http://www.austin-williams.com > > Blog: http://www.austin-williams.com/blog > Twitter: http://www.twitter.com/austin_ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > ~~~~~| > Order the Adobe Coldfusion Anthology now! > http://www.amazon.com/Adobe-Coldfusion- > Anthology/dp/1430272155/?tag=houseoffusion > Archive: http://www.houseoffusion.com/groups/cf- > talk/message.cfm/messageid:351564 > Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm > Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubs ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
