請教大家一個問題，我新學ASP不久，現在想做一個頁面從ACCESS調用數據庫
現在希望從payjilu中調用出所有該用戶的订单記錄，按以下方式做始終有問題，
有沒有高手能幫忙修改一下，告訴我錯在哪裡啊，謝謝了
代碼如下


<td>
<%dim rs2
set rs2=server.CreateObject("adodb.recordset")
rs2.open "select * from [payjilu] where username='"&trim(rs("username"))&"'",conn,1,1
end if
while not rs2.eof%>
<%response.write rs2.recordcount&"笔订单"%>        
</td>
<tr bgcolor="#FFFFFF">
<td colspan="2" align="left"><table width="600" border=1 align="center" cellPadding=0 cellSpacing=0 bordercolor="#CCCCCC" borderColorDark=#ffffff bgcolor="#F9F9F9">
              <tr>
                <td width="41" height="30"><div align="center">编号</div></td>
                <td width="111"><div align="center">交易项目</div></td>
                <td width="178"><div align="center">交易名称</div></td>
                <td width="101"><div align="center">交易价格</div></td>
                <td width="48" align="center">人數</td>
                <td width="107"><div align="center">交易时间</div></td>
              </tr>

              <tr>
                <td height="25"><div align="center"><%=rs2("id")%></div></td>
                <td><div align="center"><%=rs2("type")%></div></td>
                <td><div align="center"><%=rs2("name")%></div></td>
                <td><div align="center"><%=rs2("jiage")%></div></td>
                <td><div align="center"><%=rs2("renshu")%></div></td>
                <td><div align="center"><%=rs2("paytime")%></div></td>
              </tr>
       </table>
           <%
rs2.movenext
wend
rs2.close
end sub%>