not using a stored proc.. just a plain jane query. If you output the variable on the page, it is truncated.. if you do a count on the variable length, it returns 5000. odd.
any other thoughts? Mike -----Original Message----- From: Lofback, Chris [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 9:14 AM To: CF-Talk Subject: RE: CF 4.01 Problem If you output the field into the page as plain text rather than into the textarea, are they all displayed? Maybe it's the textarea that is giving you the problem. Maybe try adjusting the wrap properties? And this may sound odd, but if you are retrieving the data with CFPROCPARAM, try appending an empty string to the end of the data like this: <CFSTOREDPROC ... > <CFPROCPARAM TYPE="Out" CFSQLTYPE="CF_SQL_VARCHAR" DBVARNAME="v_foo" CFVARNAME="MyValue"> </CFSTOREDPROC> <CFSET MyValue = MyValue & ""> I've seen a wierd 255 character bug with CFPROCPARAM (in CF5 but it could've been around for awhile) and maybe that's what you're hitting. Chris Lofback Sr. Web Developer TRX Integration 28051 US 19 N., Ste. C Clearwater, FL 33761 www.trxi.com > -----Original Message----- > From: Tangorre, Michael [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 09, 2003 8:25 AM > To: CF-Talk > Subject: CF 4.01 Problem > > > 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
