Question

rs.open错误，提示：至少一个参数没有被指定值

1 set rs3 = server.createobject("adodb.recordset")
2 sql3 = "select * from LFHS where LHao = " & LHao
3 rs3.open sql3,connstr,1,2
4 HuXing = rs3("HXing")
5' response.write("sql3:" & HuXing & " <br>")
6 rs3.close
7 set rs3=nothing

8 set rs4 = server.createobject("adodb.recordset")
9 sql4 = "select * from HXing1 where HXing = " & HXing
10 rs4.open sql4,connstr,1,2
为什么1~3行和8~10行一样，1~3行正常运行不显示错误，而8~10行不能正常运行，提示“
Microsoft JET Database Engine 错误 '80040e10'
至少一个参数没有被指定值。”？

Answer 1

是导入EXCEL表吗？如果是检查表前面每一个字段是否有空列。

Answer 2

请检查键名是否正确，另外希望更多的上下文，只是贴出显示错部分很难找出根本原因