i posted a question not long ago about getrows, which altho i know is not the preffered method of paging (over stored procs..)
but having looked at the usage i find the follwing..
rows = value that specifies the number of records to retrieve.
start = Optional. What record to start on, a record number or a BookmarkEnum value
fields = Optional. If you want to specify only the fields that the GetRows call will return, it is possible to pass a single field name/number or an array of field names/numbers in this argument
and i am trying to use getrows liek this
oRS.Open q, oConn, 3, 1, 1
'i am told i need adOpenStatic - 3 for this to work
startRec = 10
numnPerPage = 15
if not (oRS.EOF or oRS.BOF) then
aRecs = oRS.GetRows(numPerPage, startRec)
what actually happens is the following (and yes there are recs to return)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/admin/codeinfo_test.asp, line 26
line 26 being the aRecs = oRS.getRows(x,y) line
btw in case it matters, using sql server as db