asp&Access插入数据问题(急啊!)
无法插入数据,错误在cnn.execute
<%
aa="aaaaaaabbbbb"
bb="bbbaaaaaaaaaaaa"
set cnn=server.CreateObject("adodb.connection")
cnn.connectionstring="provider=Microsoft.Jet.OleDb.4.0;data source=" & server.MapPath("database/aa.mdb")
cnn.open
if cnn.state=adstateopen then
response.Write "连接成功<br>"
end if
sqlstr="INSERT INTO bbbb(aa,bb)VALUES'"&aa&"','"&bb&"')"
response.Write sqlstr
cnn.execute sqlstr '(或cnn.execute sqlstr, ,AdCmdText) 都操作不成功
cnn.close
set cnn=nothing