请问cm.CommandText ="UPDATE TABLE alphardquestion SET job='bbbb' WHERE job=?"有何错误??
我的源码如下:
strProvider="Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\") & "\pub1.mdb;"
set objConn = server.createobject("ADODB.Connection")
objConn.Open strProvider
set cm = Server.CreateObject("ADODB.Command")
cm.ActiveConnection = objConn
cm.CommandText ="UPDATE TABLE alphardquestion SET job='bbbb' WHERE job=?"
cm.Prepared=True
cm.Parameters.Append cm.CreateParameter ("Value1",200, ,255)
cm("Value1")="aaaa"
cm.Execute
其中表alphardquestion中有字段job,类型为文本型,执行错误提示:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e21'
发生错误