帮我看看这是怎么会是?
xs = request.form("text")jz = request.form("select")
xy=request.form("text1")
tj = request.form("text2")
tt = request.form("text3")
fw = request.form("text4")
jl = request.form("text5")
gl = request.form("text6")
pt = request.form("text7")
sb = request.form("text8")
kt = request.form("text9")
bz = request.form("text10")
Response.Write(xs)
Response.Write( jz)
Response.Write(xy)
Response.Write(tj)
Response.Write(tt)
Response.Write(fw)
Response.Write(jl)
Response.Write(gl)
Response.Write(pt)
Response.Write(sb)
Response.Write(kt)
Response.Write(bz)
Set conn = Server.CreateObject("ADODB.Connection")
conn.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:\inetpub\wwwroot\gj.mdb"
set rs=server.CreateObject("adodb.recordset")
sqlstr = "select * from jd where [jd].县市='"+xs+"' and [jd].基站名称='"+jz+"'"
rs.open sqlstr ,conn ,1 ,3
rs("协议签订") = xy
rs("塔基") = tj
rs("塔体") = tt
rs("房屋") = fw
rs("交流") = jl
rs("光缆") = gl
rs("配套") = pt
rs("设备安装") = sb
rs("开通") = kt
rs("备注") = bz
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
上面是我写的代码,运行时总是提示
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10)
[Microsoft][ODBC Microsoft Access Driver] 参数不足,期待是 1。
/jindu/gengxi123.asp, 第 13 行