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
نوشته شده در
do you have an include file that defines what adGetRowsRest is supposed to be ?
نوشته شده در
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.
نوشته شده در
you have to check for an array because that is what you are being given, getRows returns an array
نوشته شده در
oh man, I should be setting the row count to "", not the array.
Thanks Huw
نوشته شده در
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.