Probably Max data length in cf admin. Look at the advanced DB connection settings. Will be set to default of 60000 characters. I ran into something similar saving a wddx variable.
Cheers, Rob On Jun 13, 2012 12:17 PM, "Robert Harrison" <[email protected]> wrote: > > 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:351566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
