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_

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. > 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 ----- Excess quoted text cut - see Original Post for more -----

He specifically said data was not list on the post. Check your dan for chat limits, you may also need to enable blob support. On Jun 13, 2012 5:19 PM, "Edward Chanter" <firewall@cc.uk.com> wrote: ----- Excess quoted text cut - see Original Post for more -----

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" <robert@austin-williams.com> wrote: ----- Excess quoted text cut - see Original Post for more -----