ÇëÎÊaccessÊý¾Ý¿âÖеÄdateÐÍ×Ö¶ÎÔÚpbÖÐÈçºÎ²éѯ£¿
accessÖÐÈÕÆÚ×Ö¶Îdate_col²éѯ¸ñʽΪ£º
select * from t where date_col>=#2010-02#
pbÖУº
DWfilter="date_col>=2010-01#"
dw_1.SetFilter(DWfilter)
dw_1.Filter£¨£©
²éѯ±¨´íÎÞЧµÄ±í´ïʽ¡£
ÇëÎÊÓÐÓùýpbµÄÅóÓÑÂð£¿
ÎÒÊÔÁËÏ£¬Èç¹û°ÑsqlдËÀ£º
select * from t_insert
where ÈÕÆÚ>=#2010-02#
Õâ¸ösqlÔÚpbÖÐÄÜÕýÈ·Ö´ÐС£²»ÓÃд³É£º#2010-02-01#
µ«ÊÇÏÖÔÚÕâ¸öÈÕÆÚÊÇÓÉÓû§´«µÄ²ÎÊý£¬²»ÖªµÀ¸ÃÔõôдÁË¡£
ÎÒ°ÑDWfilter="date_col>#2010-02-01#" »¹ÊDz»ÐС£»¹ÊÇÌáʾ¡°±í´ïʽÎÞЧ¡±
ÎÒ°Ñ×Ö¶Îд³Éstring(ÈÕÆÚ×Ö¶Î)='2010-02'£¬¿ÉÒÔ´«²ÎÊý²éѯÁË¡£
Ïà¹ØÎÊ´ð£º
×î½üѧϰasp£¬µ±Á·Ï°µ½Á¬½ÓÊý¾Ý¿âµÄʱºò£¬ÆµÆµ³ö´í£¬¿É¾ÍÊDz»ÖªµÀ´íÔÚÔõôµØ·½£¬Çë¸ßÊÖ°ïæ¿´¿´£¡£¡Ð»Ð»£¡
°üº¬Îļþxx.asp¡¢xxsave.asp¡¢conn.aspÒÔ¼°student1.mdbºÍ±íxxgl¡¡
xx.aspΪ£º
<html>
<hea ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
ÎÒÊÖ¶¯Ìí¼Ó»ùÓÚCRecordSetÀàµÄÅÉÉúÀàCODBCDemoSetÀà,ÊÇÀûÓÃclass wizardÌí¼ÓµÄ¡£²¢ÇÒ¶¨ÒåÁËÒ»¸öÈ«¾Ö±äÁ¿CODBSDemoSet*m_pCommon.µ«ÊÇÎÒ³ÌÐò²»ÄÜÔËÐС£ÎÒ¸ú×ÙÁËһϣ¬µ½ÁËm_pCommon->Isopen£¨£©´¦·¢Éú´íÎ󣬣 ......
±í½á¹¹:
table1
Ö¤¼þºÅ ʱ¼ä
X31 2010-01-11
3BC 2010-02-03
3AD 2010-02-03
F23 2010-02-09
......
ÏÖÔÚҪͳ¼ÆÒ»¸öʱ¼ä¶ÎÈç 2010-01-09 µ½ 2010-02-09¼äµÄÊý¾Ý,
ÆÚ´ý½ ......