Question

如何用ASP 获得 ACCESS 里某表的所有字段？

<!---#include file="conn.asp"--->
<% dim rs,i
set rs=server.createobject("adodb.recordset")
rs.open "select * from zhengshu",conn,1,1
for i=0 to rs.fields - 1
response.write(rs.fields(i).name)
next

if rs.eof=true and rs.bof=true then
response.write("没有数据")
else
do while not rs.eof
//具体数据
rs.movenext
loop
end if
%>

显示错误类型：
Microsoft VBScript 运行时错误 (0x800A01C2)
错误的参数个数或无效的参数属性值
/ccshidiv/admin/table.asp, 第 5 行

Answer 1

for i=0 to rs.fields - 1
response.write(rs.fields(i).name)
next
这句话有误，
应改为：
for i=0 to rs.fields.count - 1
response.write(rs.fields(i).name)
next