📄 test.asp
字号:
<!--#include file="conn.asp" -->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=big5">
<title>Untitled Document</title>
</head>
<body>
<%
date1=now()
date2="2004-8-23 12:12:39"
if datediff("s",date1,date2)> 0 then
response.write ("1")
else
response.write ("2<br>")
response.write datediff("s",date1,date2)
end if
'sql="select * from game where " & datediff("s",adddate,now())<0
sql="select GameID,MatchName from Game where Showtime<#" & now() & "# and EndTime>#" & now() & "# and ClassID=1"
'sql="select * from game where adddate<#" & cdate(now()) & "# order by GameID DESC"
set rs=conn.execute(sql)
if rs.eof then
response.write ("<br>11")
else
response.write ("<br>0<br>")
do until rs.eof
response.write rs("GameID")
response.write ("<br>")
response.write rs("MatchName")
response.write ("<br>")
rs.movenext
loop
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -