ASP bugs

22 Jun 2006 1:31 AM

brian.lukoff

Hi everyone,

I'm trying to track down some ASP bugs described at
http://www.aspfaq.com/show.asp?id=2188. Basically, I have some old
code (that used SELECT *, used rs(...) syntax but did not first store
the value in a variable before writing to the screen) and I'm trying to
determine if this old code was affected by the bug when it was run.
I'm trying to determine if there is a version of MDAC such that code
running on that version or a newer version will not be affected by the
bug, regardless of the coding practices used (or the method used to
connect to the database).

Brian

22 Jun 2006 7:18 PM

Mike Brind

brian.luk***@gmail.com wrote:

> Hi everyone,
>
> I'm trying to track down some ASP bugs described at
> http://www.aspfaq.com/show.asp?id=2188. Basically, I have some old
> code (that used SELECT *, used rs(...) syntax but did not first store
> the value in a variable before writing to the screen) and I'm trying to
> determine if this old code was affected by the bug when it was run.
> I'm trying to determine if there is a version of MDAC such that code
> running on that version or a newer version will not be affected by the
> bug, regardless of the coding practices used (or the method used to
> connect to the database).
>
> Brian

Apparently, this doesn't happen with MDAC 2.1sp2 or higher:
http://support.microsoft.com/kb/175239/EN-US/

--
Mike Brind

24 Jun 2006 1:53 AM

rori.gallagher

Hi Mike,

Thanks for your help. That KB article seems to refer to a bug where an
error occurs--I'm concerned about the case described in that aspfaq
article where there is no error, but the data simply doesn't show up at
all or doesn't after the first time accessing the field. (Also, I'm
concerned about the case with very large varchar columns, not text
columns.) Were all of these bugs fixed at the same time? Also,
someone in asp.db pointed out to me that in the "applies to" section,
MDAC 2.6, 2.7, and 2.8 are referenced--any ideas as to why this would
be?

Brian

Mike Brind wrote:
Show quote

> brian.luk***@gmail.com wrote:
> > Hi everyone,
> >
> > I'm trying to track down some ASP bugs described at
> > http://www.aspfaq.com/show.asp?id=2188. Basically, I have some old
> > code (that used SELECT *, used rs(...) syntax but did not first store
> > the value in a variable before writing to the screen) and I'm trying to
> > determine if this old code was affected by the bug when it was run.
> > I'm trying to determine if there is a version of MDAC such that code
> > running on that version or a newer version will not be affected by the
> > bug, regardless of the coding practices used (or the method used to
> > connect to the database).
> >
> > Brian
>
> Apparently, this doesn't happen with MDAC 2.1sp2 or higher:
> http://support.microsoft.com/kb/175239/EN-US/
>
> --
> Mike Brind