hi guys... please help! <BR><BR><BR>i have been troubled by these two problems over the past few weeks.... <BR>1) i am using a in between sql to queries my database and if else conditions with statement to check for the values in between the two values selectd using the sql statement. however this only allows me to check the 1st values and not the values between the 1st and last selected values. <BR>Can any one please guide me how to do? <BR><BR>codes: <BR><BR>sql = "SELECT UserID,Avail FROM Zones WHERE Week = "&Request.Form("weeks")&" AND Day = '"&Request.Form("days")&"' AND Character = '"&Request.Form("location")&"' AND Starttime AND Endtime BETWEEN "&Request.Form("times")&" AND "&Request.Form("timesno")&"" <BR>rs.Open sql, conn,1 <BR><BR><BR>do until rs.EOF <BR>if (strComp(rs("Avail"),"") = 1)then <BR>iCount=iCount - 1 <BR><BR>else <BR>iCount=iCount + 1 <BR>end if <BR><BR>rs.MoveNext <BR>loop <BR><BR>if iCount <> rs.RecordCount then <BR>'Response.Redirect "../staff/disapproved_page.asp" <BR><BR><BR>2) how to clear or delete a session instead of remove all sessions using session.abandon?