Dumping an entire array to the screen

[Ray at]

for iCounter = 0 to ubound(TheArray)
response.write TheArray(iCounter) & "<br />"
next

Ray at work


"Jacob" <yak2016@comcast.net> wrote in message
news:e$Qx4UKRDHA.2344@TK2MSFTNGP12.phx.gbl...

> Is there a way I can dump all the contents of an array to the browser for
> viewing. I'm using rs.GetRows to create the array, but my functions are
> only processing the first three records in what should be a 9 record set.
> So I'd like to dump the array to find out if it is a bad select statement

or

> bad processing of the array itself by my functions.
>
> Thanks, Jacob
>
>

[Dave Anderson]

"Jacob" wrote:

>
> Is there a way I can dump all the contents of an array to the browser for
> viewing. I'm using rs.GetRows to create the array, but my functions are
> only processing the first three records in what should be a 9 record set.
> So I'd like to dump the array to find out if it is a bad select statement

or

> bad processing of the array itself by my functions.

assuming { a = rs.GetRows() }...

JScript:
Response.Write(a.join("<BR>"))

VBScript:
Response.Write Join(a,"<BR>")


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.

[Ray at]

That was pretty clever.

Ray at work

"Dave Anderson" <GTSPXOESSGOQ@spammotel.com> wrote in message
news:%23M4mViKRDHA.2320@TK2MSFTNGP12.phx.gbl...

> "Jacob" wrote:

> >
> > Is there a way I can dump all the contents of an array to the browser

for

> > viewing. I'm using rs.GetRows to create the array, but my functions are
> > only processing the first three records in what should be a 9 record

set.

> > So I'd like to dump the array to find out if it is a bad select

statement

> or

> > bad processing of the array itself by my functions.

>
> assuming { a = rs.GetRows() }...
>
> JScript:
> Response.Write(a.join("<BR>"))
>
> VBScript:
> Response.Write Join(a,"<BR>")
>
>
> --
> Dave Anderson
>
> Unsolicited commercial email will be read at a cost of $500 per message.

Use

> of this email address implies consent to these terms. Please do not

contact

> me directly or ask me to contact you directly for assistance. If your
> question is worth asking, it's worth posting.
>
>

[Dave Anderson]

I wrote:

>
> JScript:
> Response.Write(a.join("<BR>"))

[Correction]
Since GetRows returns a SafeArray, JScript needs a little bit of tweaking.
This will simply dump the array with a line break between elements:

Response.Write(new VBArray(rs.GetRows()).toArray().join("<BR>"))

Unfortunately, the 2D nature of the array is lost, so if you want a line per
record, use rs.GetString():

Response.Write(RS.GetString(2,100,",","<BR>","null "))

Come to think of it, that's a better way for VBScript as well.


--
Dave Anderson

Unsolicited commercial email will be read at a cost of $500 per message. Use
of this email address implies consent to these terms. Please do not contact
me directly or ask me to contact you directly for assistance. If your
question is worth asking, it's worth posting.