干货零食批发市场:程序问题,这段代码有误吗?

来源:百度文库 编辑:杭州交通信息网 时间:2024/05/09 06:11:43
<%
Conn.Execute("Update xinxi Set b=0 where DateDiff('D',fbsj,now())>="&b_y&" and yz=1")
Conn.Execute("Update xinxi Set tuijian=0 where DateDiff('D',fbsj,now())>="&tui_y&" and yz=1")
closedb
function cnmaisj(sj_1)
dim sj
sj=DateDiff("D",sj_1,now())
if sj<=1 then
response.write "<font color=""#FF0000"">今天</font><img src=""images/new.gif"">"
elseif sj<=2 and sj>1 then
response.write "<font color=""#0000FF"">昨天"&timevalue(sj_1)&"</font>"
elseif sj>2 and sj<=3 then
response.write "<font color=""#008080"">前天"&timevalue(sj_1)&"</font>"
elseif sj>3 then
response.write "<font color=#353535>"&datevalue(sj_1)&"</font>"
end if
end function
%>