retrieve info problem

[lamberg]

Hi all
I am retrieving info from database to be display in a form. These two fields, which is save as "int" (program_id) is display in drop down box form.
<%
program_id = rs("desc1")
program_id = rs("desc2")
%>

<select name="desc1">
<option value="0"></option>
<%
sql = "select program_id, program_name from program order by program_id"
rs.open sql,strconnect,0,1
while not rs.eof
if program_id = Clng(rs("program_id")) then
response.write "<option value=" & rs("program_id") & " selected>" & rs("program_name") & "</option>"
else
response.write "<option value=" & rs("program_id") & ">" & rs("program_name&qu -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[cook]

The problem is that for both drop down u r using same query

Code:
sql = "select program_id, program_name from program order by program_id"

Bye -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --