米罗 milo 天蝎座:asp语法错误
来源:百度文库 编辑:高校问答 时间:2024/04/28 06:21:52
大家旁忙看看,这段代码有何问题,总是出错。
谢谢!
<%@ language=VBScript %>
<!--#include file=conn.asp-->
<%
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from 12"
rs.open sqlstr,conn1,1,3
rs.movefirst
while not rs.eof
response.write(rs("name"))
rs.movenext
wend
rs.close
conn1.close
set rs=nothing
set conn1=nothing
%>
谢谢!
<%@ language=VBScript %>
<!--#include file=conn.asp-->
<%
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from 12"
rs.open sqlstr,conn1,1,3
rs.movefirst
while not rs.eof
response.write(rs("name"))
rs.movenext
wend
rs.close
conn1.close
set rs=nothing
set conn1=nothing
%>
改成这样试一试
<%@ language=VBScript %>
<!--#include file=conn.asp-->
<%
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from 12"
rs.open sqlstr,conn1,3,2
while not rs.eof
response.write(rs("name"))
rs.movenext
wend
rs.close
conn1.close
set rs=nothing
set conn1=nothing
%>
rs.movefirst
去掉这段
sqlstr="select * from 12"
这段改成:sqlstr="select * from [12]" 即可