Ken,



I think an example of getrows() is necessary.



Most ASP/ADO programmers may not be

aware of the array structure returned by 

getrows(), nor of the optional parameters to getrows().



getrows() has three optional parameters.



arrayRS = rs.getwows([rows, start, fields])



rows = GetRowsOptionEnum 

From adovbs.inc

'---- GetRowsOptionEnum Values ----

Const adGetRowsRest = -1



start = BookMarkEnum 

From adovbs.inc

'---- enum Values ----

Const adBookmarkCurrent = 0

Const adBookmarkFirst = 1

Const adBookmarkLast = 2



fields = the name of a single column or an array of column names



getrows() returns a two-dimensional array. The first dimension

contains the columns, the second contains the records (or row number)



An example:



'Assume connection object

'Assume returned recordset



arrayRS = authorsRS.getrows() ' assume defaults



' now write to screen

for i = 0 To UBound(arrayRS, 2)

    for x = 0 to Ubound(arrayRS, 1)

         response.write(arrayRS(x, i))

        response.write("<BR>")

    next

next