连接数据库后用下面的语句查看一下:记录集对象为objRs:
--------------------------------------------------
for i = 0 to objRs.Fields.Count-1
Response.Write objRs.fields(i).name
next
--------------------------------------------------
<!--#include file="conn.asp" -->
<%
sql="select * from table1"
set rs=conn.execute(sql)
do while not rs.eof
on error resume next
response.write rs("ddd")
if err.number<>0 then
response.write "错误信息为:"+err.description
err.clear
exit do
end if
rs.movenext
loop
set rs=nothing
conn.close
set conn=nothing
%>