How to do SQL query in a ASP while loop

superman2004 · #1 (**permalink**) 09-07-04, 05:04 AM

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

Code:

    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

chirag · #2 (**permalink**) 09-08-04, 09:28 AM

Hi,

Certainly you can.
Try following code.....

==================================
DO WHILE NOT rs6.eof
sql5 = "SELECT * FROM CK_MO_Testing WHERE Read_Flag = '0' AND Message like 'CK "&rs6("Name")&"%'"

if rs5.state = adstateopen then
rs5.close
end if

rs5.open sql5, conn1
IF rs5.eof AND rs5.bof THEN
response.write "Nothing"
ELSE
response.write rs5("Message")
END IF
LOOP
========================
enjoy!!!

superman2004 · #3 (**permalink**) 09-09-04, 03:35 AM

Quote:

Originally Posted by chirag

Hi,

Certainly you can.
Try following code.....

==================================
DO WHILE NOT rs6.eof
sql5 = "SELECT * FROM CK_MO_Testing WHERE Read_Flag = '0' AND Message like 'CK "&rs6("Name")&"%'"

if rs5.state = adstateopen then
rs5.close
end if

rs5.open sql5, conn1
IF rs5.eof AND rs5.bof THEN
response.write "Nothing"
ELSE
response.write rs5("Message")
END IF
LOOP
========================
enjoy!!!

THANKS it is work oredi