<%
CategoryId=ClassRs("CategoryId")'已知道新闻类别的ID
do while not rs.eof
if Cint(CategoryId)=rs("CategoryId") then
response.write "<option value='' selected>"&&"</>"
else
response.write "<...>"
end if
rs.movenext
loop
%>
看看我的这个
也许有用
<td class="tdbg" align="right">类别:</td>
<td class="tdbg">
<select name="jokeClass">
<%
Dim strTemp
Dim i
Call openDB
strSQL = "Select * from jokeClass"
objRS.Open strSQL, objCONN, 1, 1
If objRS.EOF Or objRS.BOF Then
Response.Write("<sctipt language='javascript' typt='text/javascript'>alert('请先添加分类');</script>")
Response.Redirect("NewClass.htm")
Else
objRS.MoveFirst
For i = 1 To objRS.RecordCount
If sJokeClass = objRS("jokeClass") Then
strTemp = strTemp & "<option selected value='"&objRS("jokeClass")&"'>"&objRS("className")&"</option>"
Else
strTemp = strTemp & "<option value='"&objRS("jokeClass")&"'>"&objRS("className")&"</option>"
End If
objRS.MoveNext
Next
End If
Response.Write(strTemp)
Call closeDB
%>
</select>
</td>
</tr>