第一次用command对象就出问题,大侠帮忙!
我的源程序:
set cnn=server.createObject("ADODB.CONNECTION")
cnn.open "DBQ="+server.mappath("test.mdb")+";DRIVER={Microsoft Access Driver (*.mdb)};"
Set cmd=Server.Createobject("ADODB.Command")
cmd.ActiveConnection=cnn
cmd.commandText="select * from testtable where id=?"
cmd.commandType=adCmdText
cmd.Prepared = True
set param=cmd.CreateParameter("id",adInteger,adParamInput,,4)
cmd.Parameters.Append param
set rs=cmd.Execute
运行时,报错:
ADODB.Command 错误 '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/test.asp,行8
即cmd.commandType=adCmdText行,把此行去掉则set param=cmd.CreateParameter("id",adInteger,adParamInput,,4)行报错,错误一样。
但去掉参数那部分,后面几句改为:
cmd.commandText="select * from testtable"
cmd.Prepared = True
set rs=cmd.Execute
则没问题,我语法应该没有错啊?到底是什么问题?