asp表格输出不了

来源：百度知道 编辑：UC知道 时间：2024/05/29 15:07:13
<%
sql="select *from yunnan where df like '张%'"
rs.open sql,conn,1,3
response.Write "<center>"&"<table border='1' cellpadding='1' cellspacing='1'>"
do while not rs.eof %>
<tr>
<td align="center" bgcolor="#0000FF" ><% =rs(1) %></td>
<td align="center"><% =rs(2) %></td>
<td align="center"><% =rs(3) %></td>
</tr><br />
<% rs.movenext
loop
response.Write "</table>"&"</center>"
%>
什么都没有输出。
------------------------------------------------------------
<%
sql="select *from yunnan where df like '张%'"
rs.open sql,conn,1,3
do while not rs.eof %>
<tr>
<td align="center" bgcolor="#0000FF" ><% =rs(1) %>&

<%
DbPath = SERVER.MapPath("数据库名称")
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DbPath
set rs=server.CreateObject("ADODB.recordset")
sql="select *from yunnan where df like '张%'"
rs.open sql,conn,1,3
response.Write "<center>"&"<table border='1' cellpadding='1' cellspacing='1'>"
do while not rs.eof %>
<tr>
<td align="center" bgcolor="#0000FF" ><% =rs(1) %></td>
<td align="center"><% =rs(2) %></td>
<td align="center"><% =rs(3) %></td>
</tr><br />
<% rs.movenext
loop
response.Write "</table>"&"</center>"
%>
还有你的DF是什么意思!我测试时将它出掉了!!