I have following loop. but something is wrong with this loop that i cannot understand. it gets stuck in the loop. PLEASE HELP..
My recordset comes in following format:

id ---- drug

171 --- Coreg
171 --- Avandia
171 --- RS
132--- Coreg
133 --- Avandia
133 --- RS
AND SO ON...

MY CODE:


RS_SpeakerID=""
If (Not objRs.EOF) Then

Do While (NOT objRs.EOF)
if (RS_ID<>objRs("ID")) then

RS_ID= objRs("ID")
count=0

end if


Do while ((objRs("ID")=RS_ID) and (count=0))

if ((objRs("Drug"))="Coreg") then
response.write "match"


count=1

else


count=0

end if

objRs.MoveNext
LOOP



if (count=0) then

response.write "no match"
end if



objRs.MoveNext
Loop
END IF

what are you trying to achieve ??

Because I can't work out exactly what it is from the code above. But whatever it is you seem to be taking a long winded approach.

moving a record set from two different while loops????? what do you want to do??