Re: recordset fragility

From: Aaron Bertrand [MVP] (aaron_at_TRASHaspfaq.com)
Date: 03/30/04


Date: Tue, 30 Mar 2004 14:54:38 -0500


> Long lines would cause the behaviour I expereinced.

Only if they are surrounded with a <pre> tag, which I thought you said you
weren't using.

> The reason I can't grab the value right at the beginning is this recordset
> has many records, and I'm iterating through them... trying to watch along
> the way for "cell busters" or lines that are long with no space and are
> wrecking my layout, and fix them as they are encountered.

So?

do while not rs.eof
    bigValueThatWillBreak = rs("column")
    ... do other stuff ...
    rs.movenext
loop

> And I will indeed have lines longer than 60 chars without a break in them.

Why? What kind of gibberish are people entering? I was talking about a
space, not a carriage return. And remember that a carriage return in a
textarea is NOT the same as a <br> in HTML.

A



Relevant Pages