I want to dunamic drop downs list please help

Hi,
   Get the value and the text from the Database by using query...

let Query be strSql="select col_value,col_text from table_name"
let Recordset be ..."objRs"..


<select name=select1>
<%While not objRs.eof%>
<option value=<%=objRs("col_value")%>>objrs("col_text")</option>
<%
objrs.movenext
wend
%>



The above code will give you the dynamic dropdown..
thanks
Suresh