Question

asp数据库 access更新问题 提示 参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

bianhao=request("bianhao")
jine=request("jine")

set rs=server.CreateObject("adodb.recordset")
rs.open "select * from OrderBase where OrderID=='"&bianhao&"'",conn,1,3
do while not rs.eof

rs("OrderState")=3
rs("PayStyleId")=1
rs("ShiFuPrice")="&jine&"
rs.Update

rs.movenext
loop

rs.Close
set rs=nothing

Answer 1

因为编号是数字改为这样试试
sql = "select * from OrderBase where OrderID="&bianhao
rs.open sql,conn,1,3

Answer 2

bianhao参数应该是Object类型的,应该转换成Int类型吧!