i have a long query and would like to be able to check it to see if it is 
done yet and do a loop if it is not

this is what i'm doing

CONN_STRING = "PROVIDER=" & ProviderName & ";DRIVER=" & DriverName 
& ";SERVER=" & ServerName & ";DATABASE=Oasis_Depot;UID=" & UID & ";PWD=" & 
PWD
set cmd = server.CreateObject("adodb.command")

sql = "exec spt_time_delay '" & request("time") & "'"

cmd.ActiveConnection = conn_string
cmd.CommandText = sql 
cmd.CommandTimeout = 0
set rs = cmd.Execute(sql,,adAsyncExecute)

the query that i'm running is a time delay that waits for a period of 
time.  what i want to do is while it is waiting for the query i want check 
the state of the recordset to see if it is done querying yet and if it 
isn't then i want to go into  a loop until it is done.  i am having 
problems with recordset state property and how it works    

any help would be helpful   -Luke