|
蓝森林 http://www.lslnet.com 2006年8月25日 8:28
[asp]关于数据更新
我用下面代码
[code]
if Request.QueryString("action") = 2 then
set editclock = Server.CreateObject("ADODB.Command")
editclock.ActiveConnection = MM_articleconn_STRING
if Request.QueryString("clcok")="0" then
editclock.CommandText = "UPDATE article SET a_clock = '0' WHERE a_id = 1"
else
editclock.CommandText = "UPDATE article SET a_clock = '1' WHERE a_id = 1"
end if
editclock.CommandType = 1
editclock.CommandTimeout = 0
editclock.Prepared = true
editclock.Execute()
end if
[/code]
可是为什么他只是执行
sql第一条
editclock.CommandText = "UPDATE article SET a_clock = '0' WHERE a_id = 1"
而下面那个不起作呢?? |
|