看看这个:
<!-- #include file="xx.inc" -->
<%
sql="select * from a"
set rs=dbc.execute(sql)
if not rs.eof then
response.write "<div align='center'><table border='0' cellpadding='2' cellspacing='1' bgcolor='#006699' width='500'>"
response.write "<tr bgcolor='#ffffff'>"
response.write "<td colspan='9'> test"
response.write "<tr bgcolor='#ebebeb'>"
for i=0 to rs.fields.count-1
response.write "<td><font color='#ffffff'></font>"&rs.fields(i).name &"</font></td>"
next
number=0
do while not rs.eof
number=number+1
response.write "<tr bgcolor='#ffffff'>"
for i=0 to rs.fields.count-1
response.write "<td>"&rs.fields(i).value &"</td>"
next
rs.movenext
loop
response.write "</table>"
response.write "</div>"
else
response.write "<center><b>对不起,没有符合的记录!</b></center>"
response.write "<center><a href='#' onclick='javascript:history.go(-1);'>返回</a></center>"
end if
%>