Quote:
Originally posted by Parasu Raman
Hi Chenko,
Here is the code which I use. Kindly help me
<select name="brk_air">
<%
' dim var_sel_brk_air
rs.open "select * from schenker_master",cn,0,1
rs.movefirst
while not rs.EOF
if rs("prospect_id") = var_ses_pros_id then
var_sel_brk_air = rs("brk_air_name")
end if
rs.movenext
wend
rs.close
rs.open "select * from schenker_broker_air",cn,0,1
rs.movefirst
while not rs.EOF
if rs("brk_air_name") = var_sel_brk_air then
response.write ("<option value='" & rs("brk_air_name") & "' selected>" & rs("brk_air_name") & "</option>")
else
response.write ("<option value='" & rs("brk_air_name") & "'>" & rs("brk_air_name") & "</option>")
end if
rs.movenext
wend
rs.close
%>
</select>
</td>
</tr>
..
..
Ok, ive edited your code, I put ' ' in as you are using response.write, and also you needed a space before the "selected"