批量执行sql语句
我这代码想批量执行sql语句来修改数据库，执行后没有提示，但数据没有修改
<%connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
server.MapPath("/database/sdf12312.mdb") & ";Persist Security
Info=False"
Set conn=Server.CreateObject("ADODB.CONNECTION")
conn.open connstr
conn.execute("update PE_Soft set ClassID=441 where ClassID=78 and
(softname like '*半期*' or softname like '*期中*')")
conn.execute("update PE_Soft set ClassID=442 where ClassID=79 and
(softname like '*半期*' or softname like '*期中*')")
%>
帮我做一份完整的，谢谢！！！
[此贴子已经被作者于2006-4-21 12:16:02编辑过]
