不用关键字view试试:set rs = server.createobject("adodb.recordset") rs.open "select * from view1",conn,1,1 do while not rs.eof
'试试 set rs = server.createobject("adodb.recordset") rs.open "select * from [view]",conn,1,1 while rs.eof=false 显示内容语句 rs.movenext wend rs.close set rs = nothing
set rs = server.createobject("adodb.recordset") rs.open "select * from view1",conn,1,1response.write "jilu="&rs.recordcount response.enddo while not rs.eof 中间加了个显示记录个数的都能显示出来记录集个数,就是到了do循环后面就显示不出来了,也没有提示错误,就是打不开,我得do循环里也只是显示rs("id")啊,郁闷
rs.open "select * from view1",conn,1,1
do while not rs.eof
set rs = server.createobject("adodb.recordset")
rs.open "select * from [view]",conn,1,1
while rs.eof=false 显示内容语句 rs.movenext
wend
rs.close
set rs = nothing
rs.open "select * from view1",conn,1,1response.write "jilu="&rs.recordcount
response.enddo while not rs.eof
中间加了个显示记录个数的都能显示出来记录集个数,就是到了do循环后面就显示不出来了,也没有提示错误,就是打不开,我得do循环里也只是显示rs("id")啊,郁闷