ÓÃASPÔõôдÒÔÏ´úÂë
µ±½áÊøÊ±¼ä´óÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδÍê³É
µ±½áÊøÊ±¼äСÓÚ¿ªÊ¼Ê±¼äÔòÏÔʾδ´ïµ½ÈÎÎñ
ûÓÐʱ¼äÔòÏÔʾÕýÔÚ½øÐÐÖÐ
asp´úÂëÓ¦¸ÃÔõôд
Èç:¿ªÊ¼Ê±¼ä ½áÊøÊ±¼ä Íê³Éʱ¼ä ״̬
2009-10-10 2009-10-20 2009-10-15 Íê³É
2009-10-10 2009-10-20 2009-10-21 delay
2009-10-10 2009-10-20 ûÓÐʱ¼ä ÕýÔÚ½øÐÐÖÐ
1.Ñ»·ÅжÏßÂ
2.ÓÃÒ»¾äsqlÒ²ÄÜд³öÀ´
SQL code:
select startTime,endTime,finishTime,case when finishTime>endTime then 'delay' when endTime<finishTime then 'Íê³É' when finishTime is null then 'ÕýÔÚ½øÐÐÖÐ' end as status from table
ÎÒ¾õµÃÁÖÕÑдµÃ±È½ÏºÃ±È½Ï·ûºÏÌâÒâ
ţţ »»Ò»ÖÖ½â¾ö·½·¨ Ò²²»´í
1LµÄºÜºÃ°¡
Ïà¹ØÎÊ´ð£º
dim idi=request.QueryString("id")
set rs=server.createobject("adodb.recordset")
rs.open"select * from fang where id=194",conn,1,1
%>
......
form ±íµ¥ ÓÃÁËenctype="multipart/form-data"ºóÔõôÑù½ÓÊÕ±íµ¥µÄÊý¾Ý°¡?
ÓÃrequest.form("name")È¡²»µ½°¡!
set upload=new upload_5xsoft
response.write upload.form("userName ......
ÎҵĸùĿ¼ÊÇweb ÉÏ´«ÎļþÊÇweb/index.asp Êý¾Ý¿âÊÇweb/Data/Magic.mdb Êý¾Ý¿âÖÐÓиö±ípic ±íÖÐÓÐ×Ö¶Îpicname¡¢username¡¢Addtime¡¢addname¡¢location¡¢pp
×Ö¶ÎpicnameÄܲåÈëÊý¾Ý¡¢×Ö¶ÎlocationÒ ......
<!--#include file="Conn.asp"-->
<body>
<table border="0" align="left" cellpadding="0" cellspacing="0">
<%
URL ......
news±íÀïÓÐpname(ÉÏ²ã¿ÆÄ¿),mname(¿ÆÄ¿),type(·ÖÀà)ÕâÈý¸ö×Ö¶Î;
ÏÂÃæÕâ¸öµÝ¹é.ʵÑé²âÊÔÖ»Äܵݹ鵽110²ã..ÐèÒªÔõô¸Ä,²ÅÄÜÎÞÏÞ??
JScript code:
function gethz(pname8,type8)
dim str,rs
......