Checking if object exists 1

[CassidyHunt]

I have a class that I created in vbscript that I use to get results from the database. Sometimes I return no results or an empty object. How do I check that object to make sure it isn't empty? I have tried isnull and also seen if it = "" but neither work. Another key is they are all arrays. I tried seeing if the ubound of the array > 0 or 1 but no luck there I get an error for ubound on it.

I know I could just trap the error and move on but that seems to be the easy way out. Any other ideas?

 

[DotNetGnat]

did you try IsEmpty()

-DNG

 

[DotNetGnat]

other option is to check if the Len() is zero...

-DNG

 

[DotNetGnat]

oops...you mentioned that they are arrays...then this should work...

if UBound(myarray)=-1 then
'array is empty
else
'array has atleast one element
end if

-DNG

 

[CassidyHunt]

I used isempty and it works great. That was bone headed of me. I have done that before.

Thank you

CAssidy

 

[DotNetGnat]

Glad to help.

-DNG