Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

accessÁбí¿òÊý¾Ý¶ªÊ§

¸÷λ´óÏÀ£º
            ÔÚ´°ÌåÀïÓÐÒ»Áбí¿ò£¬ÃûÔ»¡°ÉÌÆ·±àºÅ¡±£¬ÐÐÀ´Ô´ÀïµÄÄÚÈÝÓУºÉÌÆ·±àºÅºÍÉÌÆ·Ãû£¨À´×ÔÉÌÆ·±í£©¡£
  µ«ÊÇÎÊÌâ³öÏÖÁË£ºÔ­À´ÉÌÆ·±íÀïµÄÉÌÆ·±àºÅÊÇ4루È磺0010£©µÄ£¬ÎªºÎÔÚ´°ÌåµÄÁбí¿òÀֻÏÔʾ10ÄØ£¿
  ¼´È±ÉÙÁËÇ°ÃæÁ½Î»0.£¨ÔÚÁбí¿òÀÒѾ­½«±àºÅµÄ¸ñʽÉèÖóÉ4λµÄÁË£¬»¹ÊDz»ºÃÓã¡£¡£©

        ÇëÎÊÈçºÎ²ÅÄÜʹ֮ÍêÕûµÄÏÔʾʵ¼ÊµÄλÊýÄØ£¿



ÒýÓÃ
¸Ä³É format (ÉÌÆ·±àºÅ,'0000')




ÇëÎÊÔÚÄÄÀï¸Ä°¡£¿


Ïà¹ØÎÊ´ð£º

asp´úÂ룬accessÊý¾Ý¿â£¬²éѯÎÊÌâ

Êý¾Ý¿â±íÃûΪ£ºtable1
ÆäÖÐÒ»¸ö×Ö¶ÎÃûΪ£ºname1

name1 ÖÐÄÚÈÝ¿ÉÄÜÊÇ£ºÄã ºÃ
×¢£º¡°ÄãºÃ¡±ÕâÁ½¸ö×ÖÖмäµÄ¿Õ¸ñ²»ÄÜÈ·¶¨¶àÉÙ¸ö

ÇëÎÊÔõô²ÅÄܵ±ÊäÈë¡°ÄãºÃ¡±ÕâÁ½¸ö×ÖµÄʱºò£¬¿ÉÒÔ²éѯ³öº¬ÓС°Äã&nbs ......

asp·ÃÎÊAccessÁ´½Ó±í

¸÷λÅóÓÑ£¬AccessÓëSqlserver2005Á´½Óºó£¬ÔÚaccessÖпÉÒÔ·ÃÎÊsqlserverÖеÄÊý¾Ý£¬µ«Asp·ÃÎÊaccessÖеÄÊý¾Ýʱ£¬ÌáʾMicrosoft JET Database Engine (0x80004005)
ODBC--Á¬½Óµ½ 'test' ʧ°Ü¡£

Ìù³ö´úÂ ......

Ò»¸ö×î¼òµ¥µÄaspÁ´½ÓaccessÊý¾Ý¿â½Å±¾¾ÍÊÇÎÞ·¨ÏÔʾ...

HTML code:
<HTML>
<HEAD>
<TITLE>Information Display</TITLE>
</HEAD>
<BODY>
<%
Dim conn
set conn=server.createobject ("adodb.connection")
conn ......

vbÖ´ÐÐaccess sqlÓï¾ä¹ÖÎÊÌâ

SELECT Count(*) from In_fo WHERE Reader_Time between #" + time1 + "# AND #" + time2 + "# and id=" + userid + ";

ÉÏÃæÊÇÎÒдµÄsqlÓï¾ä Reader_TimeÊÇʱ¼äÀàÐÍ idΪÊý×Ö ......

ÓÃVB´´½¨ÁËÒ»¸ö¿ÕAccess±í£¬²»ÄÜÌí¼Ó¼Ç¼

ÓÃADO´´½¨ÁËÒ»¸ö¿ÕAccess±í£¬²¢Ìí¼ÓÁ˶à¸ö×Ö¶ÎÃû¡£
µ«ÏÖÔÚÎÊÌâÊÇ£¬²»ÄÜÏò¿Õ±íÖÐÌí¼Ó¼Ç¼¡£
ÿ´ÎÌí¼Ó¶¼»á³öÏÖ¡°BOF »ò EOF ÖÐÓÐÒ»¸öÊÇ¡°Õ桱£¬»òÕßµ±Ç°µÄ¼Ç¼Òѱ»É¾³ý£¬ËùÐèµÄ²Ù×÷ÒªÇóÒ»¸öµ±Ç°µÄ¼Ç¼¡±

......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ