how can select distinct records within loop..??

<i><b>Originally posted by : dev (devb0505@yahoo.com)</b></i><br />i wanna select distinct records within loop..<br />i have got normalize database which carry one user table(which carryes unique records) and another user's skills(repeatetion of records) <br />i made a search on user's skill table and stored in a record set(repeatation is there in the record set) <br /><br />query is<br />1.got search result in record set called rs:<br />userid = rs("userid")<br />while not rs.eof <br />userid = rs("userid")<br />set rss = con.execute(select distinct(user) from user where userid = '"& userid &"')")<br />rs.movenext<br />wend<br /><br />when i execute this query it's does'nt give me distinct record i believe we cann't use distinct function in while loop bec'z every record is unique it self within loop. is there any way to select distinct records in loop ??????<br />

<i><b>Originally posted by : Dev (dev_0505@yahoo.com)</b></i><br /><br />i wanna select distinct records within loop..<br />i have got normalize database which carry one user table(which carryes unique records) and another user's skills(repeatetion of records) <br />i made a search on user's skill table and stored in a record set(repeatation is there in the record set) <br /><br />query is<br />1.got search result in record set called rs:<br />userid = rs("userid")<br />while not rs.eof <br />userid = rs("userid")<br />set rss = con.execute(select distinct(user) from user where userid = '"& userid &"')")<br />rs.movenext<br />wend<br /><br />when i execute this query it's does'nt give me distinct record i believe we cann't use distinct function in while loop bec'z every record is unique it self within loop. is there any way to select distinct records in loop ??????<br /><br /><br />------------<br />dev at 7/5/2001 6:39:45 AM<br /><br />i wanna select distinct records within loop..<br />i have got normalize database which carry one user table(which carryes unique records) and another user's skills(repeatetion of records) <br />i made a search on user's skill table and stored in a record set(repeatation is there in the record set) <br /><br />query is<br />1.got search result in record set called rs:<br />userid = rs("userid")<br />while not rs.eof <br />userid = rs("userid")<br />set rss = con.execute(select distinct(user) from user where userid = '"& userid &"')")<br />rs.movenext<br />wend<br /><br />when i execute this query it's does'nt give me distinct record i believe we cann't use distinct function in while loop bec'z every record is unique it self within loop. is there any way to select distinct records in loop ??????<br />