I am working within classic ASP and having one issue where I am trying to fill a dropdown. All is working fine but my code was pulling all users which was fine but now I have to pull only certain users based on their group. SO I have inserted a new SQL command above the original code.

My issue now is that it is grabbing from the right group, but it only grabs the first user, not all users for the dropdown. I suspect this is because I need to build a loop somewhere but my lightly experienced brain when it comes to classic asp is not able to figure this out

Any ideas?

Code:
<select name="SPECIALIST_SID">
                        
                <%
						
Call OPEN_DB()
							 
DIM SPEC_ID
							 
Call RETURN_VALUE(False)
			

<!-- This part I just added to return a certain user group -->
SQL = "SELECT * FROM mms_tbl_user_cate WHERE fldCATE_ID = 5"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.LockType   = 1
RS.CursorType = 0
RS.Open SQL, MyConn	
IF NOT RS.EOF THEN
SPEC_ID = trim(RS("fldUSER_ID"))		
END IF
RS.Close 
Set RS = Nothing	
			
<!-- Original part but this pulls all users, need to enforce group - I did add the WHERE ID = SPEC_ID below to test -->		
SQL = "SELECT ID, fldNAME FROM mms_tbl_user WHERE ID = " & SPEC_ID & " ORDER BY fldNAME ASC"
Set RS = Server.CreateObject("ADODB.Recordset")
RS.LockType   = 1
RS.CursorType = 0
RS.Open SQL, MyConn	
WHILE NOT RS.EOF 
IF SPECIALIST_SID =  trim(RS("ID")) THEN
strLEVEL = strLEVEL & "<option selected value='" & trim(RS("ID")) & "'>" & trim(RS("fldNAME")) & Vbcrlf
ELSE
strLEVEL = strLEVEL & "<option value='" & trim(RS("ID")) & "'>" & trim(RS("fldNAME")) & Vbcrlf
END IF
RS.MoveNext
WEND
RS.Close 
Set RS = Nothing	 %>

<%=strLEVEL%>
</select>