getrows (asp 3.0 not .net) 2

[Krickles]

I'm using the getrows method to return an array. No matter which table I point to, I only load half of the records (regardless of total record count). Code chunk below:

Set objRec = server.CreateObject("ADODB.Recordset")
objRec.Open "select * from division_lu", objConn

Dim arrResults, intLastCol, intLastRow, intCol, intRow

arrResults = objRec.GetRows

intLastCol = UBound(arrResults)
intLastRow = UBound(arrResults)

For intRow = 0 to intLastCol
  For intCol = 0 to intLastRow
    Response.Write arrResults(intCol, intRow) & "   "
  Next
    Response.Write (&quot;<BR>&quot;)
Next

Please advise. Regards, Krickles

 

[Genimuse]

In your example you're not being specific about which dimension you're looking for in your

Ubound()

statements. To do so use:

intLastCol = UBound(arrResults,1)
intLastRow = UBound(arrResults,2)

 

[Krickles]

When I do as recommended, the following error occurs (tried on two different tables):

Subscript out of range: 'X'

where X = number of columns in the respective table.

 

[onpnt]

Genimuse is correct but the direction on using the count may be wrong plus the subscript coding.
just a little more to the accurate count with the ubound to avoid the subscript.
check the example listed here

http://www.stardeveloper.com/articles/display.html?article=2000080601&page=1

should get your table looking spiffy, with all the records

____________________________________________________
_{$str = "sleep is good for you. sleep gives you the energy you need to function";
$Nstr = ereg_replace("sleep","coffee",$str); echo $Nstr;}

http://www.onpntwebdesigns.com

 

[codestorm]

As onpnt hinted at, the lines below are wrong:

For intRow = 0 to intLastCol
For intCol = 0 to intLastRow

Read it slowly (or perhaps read it out loud) and I think you'll notice the problem.

codestorm
Newbie Life Member.
Fire bad. Tree pretty. - Buffy
<insert witticism here>

 

[Genimuse]

Yep. My fix was correct, but I missed the second problem. Good catch, codestorm.

(I use GetRows all the time and so knew my post was correct, so I was really confused when it didn't run!)

 

[Krickles]

Thanks onpnt for the link and thanks codestorm for noting the row=col mistake. It is working now. Regards, Krickles