The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I get an error when I use GetRows(adGetRowsRest). I have to use GetRows(-1)
Also, I have to check for an array if the query comes back with rows, else I get a type mismatch error.
What could cause this?
Code:
ADODB.Recordset (0x800A0C93)
Operation is not allowed in this context.
/my_cards/set.asp, line 208
Also, I have to check for an array if the query comes back with rows, else I get a type mismatch error.
What could cause this?
Code:
Sub GetCards()
dim strSql, rs, allSRData, SetRows
strSql = "SELECT SR_CARDS FROM " & strTablePrefix & "SET_ROW " & _
"WHERE SET_ID = " & SetID & " AND SR_CARDS > 0 AND SR_ROW_TYPE = 4"
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn
if rs.EOF or rs.BOF then
allSRData = ""
else
allSRData = rs.GetRows(-1) 'adGetRowsRest draws an error
SetRows = uBound(allSRData,2)
end if
rs.close
set rs = nothing
if not isArray(allSRData) then 'if allSRData = "" then -draws an error
SetCards = 0
SetUniqueCards = 0
else
SetCards = SetRows + 1
end if
End Sub
Posted
do you have an include file that defines what adGetRowsRest is supposed to be ?
Posted
Nope 
it's been awhile. I just found that out in my search.
I still have to check for an array. I thought maybe they were connected.
it's been awhile. I just found that out in my search. I still have to check for an array. I thought maybe they were connected.
Posted
you have to check for an array because that is what you are being given, getRows returns an array
Posted
oh man, I should be setting the row count to "", not the array.
Thanks Huw
Posted
I used to use getrows() a lot years back, unless something has changed getrows() didn't return an array if you called it on an empty recordset, it used to return -1 or some other single value.
I always tested the return of getrows() with IsArray, and to make the rest of my code work right I converted the return value to an array so I could just pass along getrows() output to downstream code without having to test later on in the code.
I always tested the return of getrows() with IsArray, and to make the rest of my code work right I converted the return value to an array so I could just pass along getrows() output to downstream code without having to test later on in the code.