If the rs.EOF and rs.BOF are both true you "have no records"
it the safest way to test I've come across
... and I think its "Case is > 1" .... not that it will work here anyway
"Dthmtlgod" <do************@netzero.net> wrote in message
news:Om**************@TK2MSFTNGP12.phx.gbl...
I have this below. If there are 0 records, I want to do nothing, which it
does. I need to perform a task if there is more than one. Case > 1
doesn't work. The most records I would have are 5.
mycount=rs.recordcount
Select Case mycount
Case 0
Response.write ("No Records")
Case 1
Do Something
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (
http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 11/1/2004