[thelist] Procrastinating Variables

[Rob Smith]

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 !