即這樣一段代碼:讀取access里表S里A列的值,將這一列值放進一個下拉菜單里
<select name="fl" id="fl">
<option value="">請選擇</option>
<%
sql = "select classname from exam_class order by classorder asc" 'exam_class表名。classname字段名
set drs = conn.execute(sql)'conn是數(shù)據(jù)庫連接
if not drs.eof then
while not drs.eof
response.Write "<option value='"&drs(0)&"' "&se&">"&drs(0)&"</option>"
drs.movenext
wend
end if
drs.close
set drs = nothing
%></select>