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

ÓÃ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µÄºÜºÃ°¡


Ïà¹ØÎÊ´ð£º

ASPÁ¬½ÓMySQL³ö´í ¼±

ÎÒ×öÁËÒ»¸öASPÍøÕ¾£¨µÚÒ»´Î×ö£©£º
ÔÚÎÒµçÄÔÉÏ£¬ÎÒÏÂÁ˸öMySQLµÄODBC£¬
Á¬½ÓÓï¾ä£º
ConnStr = "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=test;USER=root;PASSWORD=123456;"
......

aspµÝ¹éÉÏÏÞµÄÎÊÌâ

news±íÀïÓÐpname(ÉÏ²ã¿ÆÄ¿),mname(¿ÆÄ¿),type(·ÖÀà)ÕâÈý¸ö×Ö¶Î;

ÏÂÃæÕâ¸öµÝ¹é.ʵÑé²âÊÔÖ»Äܵݹ鵽110²ã..ÐèÒªÔõô¸Ä,²ÅÄÜÎÞÏÞ??

JScript code:

function gethz(pname8,type8)
dim str,rs
......

ASP ×ֶαȽÏ

´ÓAcessÊý¾Ý¿âÀï²éÕÒµ½Ä³Ò»Ìõ¼Ç¼£¬Òª±È½ÏÕâÌõ¼Ç¼ÖеÄijһÁеÄÖµÊÇ·ñ°üº¬Ä³Ò»×ֶΡ£
±ÈÈ磬Êý¾Ý¶ÔËùÓеÄÓû§²Ù×÷½øÐÐÁ˼Ǽ¡£
ÔÚÈÕÖ¾²éѯÀÏë°ÑÓû§É¾³ý¼Ç¼ÒÔºìÉ«ÐÅÏ¢ÏÔʾ¡£
ÿÌõɾ³ýµÄÈÕÖ¾¼Ç¼ÀïÓÐÒ»Á ......

ÇóÒ»¸ösql Óï¾ä£¨asp£©

id lbname topid ceng
1 ²úÆ·1 0 1
16 ²úÆ·2 0 1
17 ²úÆ·3 0 1
18 ²úÆ·4 0 1
19 ²úÆ·5 0 1
20 ²úÆ·6 0 1
21 ²úÆ·7 0 1
22 ²úÆ·8 0 1
23 ²úÆ·9 0 1
24 ²úÆ·10 0 1
25 ²úÆ·11 0 1
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ