Hello all. I know CF 4.01 is acient, but gvt regs will not allow anything newer just yet. Anyways, we have a small issue with truncated data. We have a text area on a form that correctly allows for up 5000 characters. When the formis submitted, it all goes into the DB just fine. When pulling the information back out to re-populate the form field, it gets cut off at 255 characters (even though the entire 5000 was in the DB). Also, if i do a count on the characters, I get them all back in the count total (number) but not in the text area. Does anyone have any ideas on a fix? I can't seem to figure out why it displays 255 of the 5000 characters yet if you do a count on the variable holding the 5000 characters, the number 5000 is returned just fine. NT 4.0, Service Pack 6 build 1381 CF 4.01 SQL Server 7 (latest MDAC) Thanks, Michael T. Tangorre ---------------------------------------- MillenniuM Information Systems 1101 Wilson Blvd. Suite 1200 Arlington, Virginia 22209 O: 703-341-1438 C: 607-426-9277 ---------------------------------------- Golden Rule: "He who has the gold, makes the rules!"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4