|
#2
aspic2010-11-10 11:04
|
下面是7-6.asp的代码
<%
Dim cn1,rs,filepath
filepath = server.mappath("a1.mdb")
set cn1 = server.createobject("ADODB.Connection")
cn1.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & filepath
set rs = server.createobject("ADODB.recordset")
'conn.execute"delete s where 工资=1400"
'rs.Open "select * from S where 工资=1400",cn1,adOpenkeyset,adLockOptimistic
'rs.delete
'rs.Close
'Set rs=nothing
'cn1.Close
'set cn1=nothing
Response.Redirect "7-4.asp"
%>
我运行了下，查出'conn.execute"delete s where 工资=1400"有问题，可不知道问题出在那，有那位高手可以帮我解答下吗？谢谢啦
