Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ´«²ÎÊýµÄÎÊÌâ

dim idi=request.QueryString("id")
set rs=server.createobject("adodb.recordset")




rs.open"select * from fang where id=194",conn,1,1
%>
......

ASPÒ³ÃæË¢Ð£¬Í³¼ÆÔĶÁÊý

ÎÒÓÃASP×öÁËÒ»¸öÂÛÌ³Ò³Ãæ£¬ÒªÍ³¼ÆÔĶÁÊý¡£Ã¿´ò¿ªÒ³ÃæÒ»´Î¾ÍUPDATEÔĶÁÊýÄǸö×ֶΣ¬ÕâÑùÖ»ÒªÒ³ÃæË¢ÐÂÒ»´Î¾Í»áUPDATEÒ»´Î£¬ÇëÎÊÒªÔõô·ÀֹˢÐÂÒ³ÃæÀ´Ôö¼ÓÔĶÁÊý£¿
Çå³ý»º´æ ÅжÏÉÏÒ³À´Ô´µØÖ· Õâ¸öÖ»ÊÇÏë·¨ ÎÒûÓÐʵ¼ù ......

Ç뾫ͨasp³ÌÐòµÄÅóÓѰïæÐÞ¸ÄÍøÕ¾

ÎÒÃÇÓÐÒ»¸öÍøÕ¾Ä£°å£¬www.c111.com.cn,Ï£ÍûÐÞ¸ÄһЩµØ·½£º
1£©µã»÷×ó²à¡°·þÎñÆ·ÅÆ¡±µÄÆäÖÐÒ»¸öС·ÖÀ࣬Èç¡°×ãÇò¡±£¬½çÃæµÄÓÒ²à¾Í³öÏÖÈçwww.c111.com.cn/1.jpg£¬µã»÷1.jpgÉÏ·½µÄÆäÖÐÒ»¸öÆ·ÅÆlogo£¬ÏÂÃæ¾Í³öÏÖÏà¹ØµÄÍ ......

ASP ÓÃÀà²Ù×÷?

½øÀ´Î¬»¤ÁËÓÃÀà±àдµÄASPÍøÕ¾£¬¿ªÊ¼Á˽âÁË Ò»µãÀàµÄ²Ù×÷¡£
ÒÔǰ×öÍøÕ¾¶¼ÊÇÔÚ¡¶% %¡·Ð´´úÂëµÄ£¿

¿´¿´ CMSºÃÏñ¶¼ÊÇÓÃÀàдµÄ£¬×Ô¼ºÒ²¿´ÁË´úÂë ºÃÏñ±È½ÏÄÑ£¬ ¿´µÃ¶®¶¼²»ÖªµÀÒªµ½Ê²Ã´Ê±ºò²ÅÃ÷°×¡£
Í·Ôΰ¡£¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ