aspÖÐsqlÓï¾äʱ¼ä²éѯ×ܳöÏÖ´íÎó - Web ¿ª·¢ / ASP

accessÊý¾Ý¿â,ÓôÃƵÄÊÇÏàͬµÄÓï¾äʹÓ÷½Ê½,ÔÚ²»Í¬µÄÒ³Ãæ¾Í²»ÕýÈ·ÁË¡£

Çë¿´ÄÜÕý³£Ö´ÐеÄ
Sql = "select * from Tbl where Cdate(left(RegDate,10)) between #"&date()-1&"# and #"&date()-1&"# order by Id desc"

RegDateΪÎı¾¸ñʽ£¬´æ´¢Êý¾ÝΪ£º2010-04-15 10£º00£º00

³ö´íµÄΪ
Rs0.Open "select top 10 * from [Note] a where a.id in(select top 1 id from [Note] where ComId=a.ComId order by id desc) and NextDate<>'' and (Replyed='' or IsNull(Replyed)) and Cdate(NextDate) between #"&date()-7&"# and #"&date()+7&"# order by NextDate desc" , Conn_N , 1 , 1  

NextDateΪÎı¾¸ñʽ£¬´æ´¢Êý¾ÝΪ£º2010-04-15

²»¹ÜNextDate£¬Ôõô±ä£¬¶¼ÊÇÈçÏ´íÎó
 
Microsoft VBScript ±àÒëÆ÷´íÎó ´íÎó '800a03f6' 
ȱÉÙ 'End' 

/iisHelp/common/500-100.asp£¬ÐÐ242 

Microsoft JET Database Engine ´íÎó '80040e14' 

ÎÞЧµÄ null ʹÓà


ÇëÎʸÃÈçºÎ´¦ÀíÄØ£¿Ð»Ð»

---

Microsoft VBScript ±àÒëÆ÷´íÎó ´íÎó '800a03f6'  
ȱÉÙ 'End'  
¶¼ÒѾ­ËµÁË°¡

---

µ«ÊÇÎÒÈ¥µôÕâÒ»½ØCdate(NextDate) between #"&date()-7&"# and #"&date()+7&"#£¬³ÌÐòÊÇÕý³£µÄ£¬ÕâÔõôÀí½âÄØ£¿ 

»òÕßÌõ¼þÎÒֻʹÓÃCdate(NextDate) between #"&date()-7&"# and #"&date()+7&"#»¹ÊDZ¨Ïàͬ´íÎó¡£ÎÒ»