ÓÃasp¼ÆËã×ÔȻԵÄʱ¼äÎÊÌ⣡£¡ÔÚÏߵȣ¡
ʵÏֵŦÄÜ£º
ÿ¸ö×ÔȻԿÉÒÔÁìȡһ´Îϵͳ½±Àø
Èç1Ô¿ÉÒÔÁìÒ»´Î£¬2Ô¿ÉÒÔÁìÒ»´Î
ÈçºÎÅжϵ±Ç°Ê±¼äºÍÉÏ´ÎÁìÈ¡½±ÀøÊ±¼äÔÚÒ»¸ö×ÔÈ»ÔÂÄÚÄØ£¿
лл£¡
difffate
Áìȡʱ¼ä´æÏÂÀ´£¬µ±Ç°Ê±¼äͨ¹ýʱ¼ä¶Ô±Èº¯ÊýÀ´¼ÆË㣡
DateDiff(m,vtime,'"&now()&"') <"&RefuseTime
vtime ÉÏ´ÎÁìȡʱ¼ä RefuseTime ÕâÊÇÄãÏÞÖÆµÄÁìȡʱ¼ä °´Äã˵Ӧ¸ÃÊÇ1
°¡ ²»ºÃÒâʶ ´ò´íÁË ÊÇ "n" ²»ÊÇm
È¡³öµ±Ç°µÄÄêÔ£¬ºÍÊý¾Ý¿âÀï´æµÄÄêÔ±ȽÏһϣ¬Èç¹ûûÓУ¬¾ÍÔÊÐíÁ죬Èç¹ûÒѾÓÐÁË£¬±íʾÒѾÁì¹ýÁË¡£
Êý¾Ý¿âÀïµÄÄÚÈÝÊÇyyyymm¾ÍÐУ¬È磺±È½ÏµÄʱºò£¬´æÔÚ200909¾ÍÊÇ2009Äê9ÔÂÍêÊÂÁË¡£
DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]])
ÆäÖÐ interval±íʾ£¬¼ÆËã²îÖµµÄÀàÐÍ
yyyy-Äꣻq-¼¾ £»m-Ô £»y-Ò»ÄêµÄÈÕÊý £»
d-ÈÕ £»w-Ò»ÖܵÄÈÕÊý £»ww-ÖÜ £»
h-ʱ £»n-·ÖÖÓ £»s-Ãë
±ÈÈ磺¼ÆËãAµ½B
Ö®¼äµÄ·ÖÖÓʹÓÃDateDiff("n",CDate(A),CDate(B))
Óà DatediffÕâ¸ö·½·¨
Ïà¹ØÎÊ´ð£º
ÎÒÔ±¾ÊÇѧjspµÄ¿ÉÕÒÁËÒ»¸öASPµÄ¹«Ë¾£¡ÎÒÒªÖØÐÂѧϰ£¡ ѧϰASP£¡ Ï£Íû´ó¼ÒÍÆ¼öÒ»±¾ºÃÊ鏸ÎÒлл
<ASP3.0¸ß¼¶±à³Ì> ÍøÉÏÓеç×Ó°æµÄ
·¢ÏÖÍøÉÏaspÐÅϢʱ×î¶àµÄ ±ÈÆäËûµÄ¶¼¶àºÃ¶à
yun
ÕÒ±¾ÓÐÓ¦ÓÃÊÂÀýµÄA ......
ÓÐÄÄλ¸ßÊÖÓùýASP FCKÔÚÏß±à¼Æ÷ѽ£¬ËüÄǸöͼƬÉÏ´«¹¦ÄÜÔõôÅäÖÃѽ
ÄܸøÎÒ·¢¸öÄÜÓÃFCKÔÚÏß±à¼Âð£¿Ò»¶¨ÄÜÉÏ´«Í¼Æ¬¹¦ÄܵÄѽ£¬¼±Ñ½
Ö±½Óµ½¹Ù·½ÍøÕ¾È¥Ï¸ö¾Í¿ÉÒÔÁË£¬¹ØÓÚÉèÖÃô£¬Ö±½ÓGOOGLEÒ»ÏÂÄãµÄ°æ±¾ºÅ¾Í¿ÉÒÔÕÒµ ......
<%
Sql="select top 8 * from NewsData where d_classid in (select classid from NewsClass where ParentID=16)"
Rs.Open Sql, conn, 1,1
Do Until Rs.Eof
......
ÎÒÕÒÁËÒ»¸öα¾²Ì¬´úÂ룬ÈçÏ£º
index.asp
<!--#include file="config.asp"-->
<ol>
<%
Set rs=server.CreateObject("adodb.recordset") & ......