Re: large varchar columns in SQL server

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

My understanding of the bug is that it could cause a simple script like
this to fail:

Set rs = conn.Execute("SELECT * FROM x")
Response.Write rs("y")

if y is a text column. This seems like basic functionality that should
work all of the time (even with SELECT *). Any ideas how I can ensure
that this will work?

Brian

Bob Barrows [MVP] wrote:
brian.lukoff@xxxxxxxxx wrote:
I'm trying to test for the problem by running a simple query many
times
and checking to make sure that every time the query is run and a value
is retrieved using rs(field), I get the value and not a truncated or
empty string. If I am understanding the bug correctly, I should be
able to see from this whether the bug is present in my current
configuration--is this correct?


I can't say for sure, but, probably.
Again, no ironclad guarantees. My experience iinvolved an easily
reproducible symptom. Others I remember seeing in these newsgroups didn't.

Could you explain why your data's integrity is so dependant on this
functionality? I'm getting the idea from your previous posts that you are
somehow using an ADO recordset in an ASP app to perform some sort of
export/backup function ...? If so, this is definitely the wrong tool for the
job.

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

.

Relevant Pages

  • Re: large varchar columns in SQL server
    ... One more thing--a while back we had talked about a possible truncation ... This seems like basic functionality that should ... If I am understanding the bug correctly, ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • [Full-Disclosure] Seriously IE/FAME/BASHING
    ... Security dosent mean functionality. ... So if your not smart enough to secure your self ... Whinning about a simple bug eventho it can have ...
    (Full-Disclosure)
  • F7-Enter bug details & workaround
    ... F7-Enter bug details & workaround ... Who implements the history window that it shows ... application can make use of this functionality, ... I've also developed a temporary patch to solve the problem. ...
    (Bugtraq)
  • Re: Side effects in conditional expressions
    ... Because understanding the author is a very big help in understanding the ... we had a bug reported against our toolchain. ... and since many C idioms are idioms because they provide protection ... Heuristics are awesome. ...
    (comp.lang.c)
  • Re: writing to freed memory--issues
    ... I was playing around with a toy program, which led to some confusion. ... bug, just trying to understand the behavior. ... Why does the segfault keep occurring ... I figure understanding ...
    (comp.os.linux.development.apps)