Going straight to just the SQL update I have: <cfquery datasource="#dsn#"> UPDATE tbl_capabilities_categories SET capability_cat_txt2='HERE ARE 200,000 ALPHANUMERIC ONLY CHARACTERS' WHERE id=#id#; </cfquery>
capability_cat_txt2 field type is TEXT Only about 63,000 of the update characters are being updated to the field. The remainder is truncated. I am getting no truncation warning and I've certainly makde sure there is no ' in the string to cause an early end to the data. Robert B. Harrison Director of Interactive Services Austin & Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be &. Plug in to our blog: A&W Unplugged http://www.austin-williams.com/unplugged ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:342997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm