myArray = recordset.getrows

[dotnettester]

Hi,

would this code give an EOF or BOF error if there are no rows in the
recordset? or the array myArray would be just null?

Thnx.

[Bob Barrows [MVP]]

dotnettester wrote:

Hi,

would this code give an EOF or BOF error if there are no rows in the
recordset?

Yes. That is why I always do this:

dim myArray
recordset.open ...
if not recordset.eof then myArray = recordset.getrows
recordset.close:set recordset=nothing
connection.close: set connection=nothing

if isarray(myArray) then
'process it
else
'report that there were no records
end if

Bob Barrows

--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.