注册 登录
编程论坛 ASP技术论坛

怎么加时间更新功能

FFEEDD 发布于 2007-11-18 21:33, 447 次点击
下面这段代码是完整的删除代码,里面有四个表,分别是"hack" "hire" "sell" "buy".现在要它做

出判断,如果我点击的是"更新

"它怎么把与之相对应的四个表里面的"data"(时间字段),字段更新为现在的时间.

<%
dim checkbox,strSql
checkbox=request("checkbox")

if checkbox="" then %>

<SCRIPT LANGUAGE=vbscript>
<!--
msgbox("您未选择要更新或删除的记录!")
Sub window_onload
window.history.back
End Sub
-->
</SCRIPT>

<% response.end
end if

checkbox=replace(checkbox," ","")
checkbox=replace(checkbox,","," or id=")

if session("house")="hack" then
strSql="delete from [hack] where id=" & checkbox
end if
if session("house")="hire" then
strSql="delete from [hire] where id=" & checkbox
end if
if session("house")="sell" then
strSql="delete from [sell] where id=" & checkbox
end if
if session("house")="buy" then
strSql="delete from [buy] where id=" & checkbox
end if
conn.execute(strSql)
response.redirect "view_house.asp?house=" & session("house")

%>
3 回复
#2
FFEEDD2007-11-18 21:33
回复:(FFEEDD)怎么加时间更新功能
前面要加个判断语句
dim an

if an = "删 除" then

if an = "更 新" then

就这之类的东西,后面也是要判断.
#3
kira0072007-11-19 11:05
if an = "更 新" then

if session("house")="hack" then
strSql="set date=now() from [hack] where id=" & checkbox
end if
if session("house")="hire" then
strSql="set date=now() from [hire] where id=" & checkbox
end if
if session("house")="sell" then
strSql="set date=now() from [sell] where id=" & checkbox
end if
if session("house")="buy" then
strSql="set date=now() from [buy] where id=" & checkbox
end if

conn.execute(strSql)
response.redirect "view_house.asp?house=" & session("house")
end if
#4
FFEEDD2007-11-20 21:05
谢谢,感激不尽
1