This happens: Microsoft OLE DB Provider for ODBC Drivers error '80040e21' Errors occurred /product/product.asp, line 227 :-\ Rob -----Original Message----- From: Joshua Olson [mailto:joshua at waetech.com] Sent: Thursday, December 12, 2002 10:07 AM To: thelist at lists.evolt.org Subject: Re: [thelist] Procrastinating Variables ----- Original Message ----- From: "Rob Smith" <rob.smith at THERMON.com> Sent: Thursday, December 12, 2002 11:02 AM > Greetings oh non-maleficent ones, > > ... that maybe counter intuitive since we know enough to do some damage... > anyway. I have a problem that I've never seen before with SQL Server 2k. > > I've got a Column varChar(2056) that contains a bunch of text/links; the > character count of this data is only 416. I'm calling it via ASP and > displaying it normally too. However, it doesn't display the entire contents > of the cell. It looks like it is displaying the first 254 of the 416 characters? This sounds like it may be a ADO problem or perhaps you have a Convert, Cast, or Trim in the query or view? What happens when the datatype is changed to text? -joshua -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !