Y i cant do SQL Query in ASP while loop, do until, do while loop ?

    DO WHILE NOT rs6.eof
   sql5 = "SELECT * FROM CK_MO_Testing WHERE Read_Flag = '0' AND Message like 'CK "&rs6("Name")&"%'"
   rs5.open sql5, conn1
   IF rs5.eof AND rs5.bof THEN
	response.write "Nothing"
   ELSE
	response.write rs5("Message")
   END IF
  LOOP

Please help me

superman,

I'm not sure if it is the only thing wrong with your code but it is an infinite loop because rs6 is never incremented (rs6.moveNext).

Are you getting an error or what is going on when you attempt to run the code? I assume it just never comes back because of the infinite loop.

MtnMinded

thanks, now i found the way to do it oredi