asp 显示数据

[不神奇]

<table id="hot_area3"><tr><td>

<% sql_hot1="select top 10 * from product where ptype='学生 and pstate like '%热点%' order by sj"
set rs_hot1=server.CreateObject("aDODB.recordset")
rs_hot1.open sql_hot1,dbconn,3,3
%>

<ul><li><%=rs_hot1("js")%></li></ul>

<%
rs_hot1.MoveNext
%>

<td></tr></table>




执行完sql后有3条数据
我要分别写到3个<ul></ul>中

现在的读出数据后就只显示第一条数据，要怎么写？？

[sumjor]

<table id="hot_area3"> <tr> <td>

<% sql_hot1="select top 10 * from product where ptype='学生 and pstate like '%热点%' order by sj"
set rs_hot1=server.CreateObject("aDODB.recordset")
rs_hot1.open sql_hot1,dbconn,3,3
do not rs_hot1.eof
%>

<ul> <li> <%=rs_hot1("js")%> </li> </ul>

<%
rs_hot1.MoveNext
loop
%>

<td> </tr> </table>

[liuwei_IT_love]

楼上的方法就可以

[anbs01]

<table id="hot_area3">
	<tr>
		<td>
<%
sql_hot1="select top 10 * from product where ptype='学生 and  pstate like '%热点%'  order by sj" 
set rs_hot1=server.CreateObject("aDODB.recordset") 
rs_hot1.open sql_hot1,dbconn,3,3 
do while not rs_hot1.eof%>
			<ul>
				<li> <%=rs_hot1("js")%> </li>
			</ul>
<% 
rs_hot1.MoveNext 
loop%>
		<td>
	</tr>
</table>

[不神奇]

我语句是不是写错了
怎么执行出错 http 500错误

[不神奇]

搞定 少写了个while

[sumjor]

下次给点分。。。。。唉