Question

ASP报错 参数不足期待是1

我的代码
<%
dim jintian
jintian=date()
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from info1 where date2 between "&jintian&" and "&jintian&" "
rs.open sqlstr,conn,1,3
rs.movefirst
while not rs.eof
response.write(rs("card"))
rs.movenext
wend
%>

Answer 1

把 rs.open sqlstr,conn,1,3
改为 rs.open sqlstr,conn,1,1
试试