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

ÎҵĸùĿ¼ÊÇweb ÉÏ´«ÎļþÊÇweb/index.asp  Êý¾Ý¿âÊÇweb/Data/Magic.mdb Êý¾Ý¿âÖÐÓиö±ípic  ±íÖÐÓÐ×Ö¶Îpicname¡¢username¡¢Addtime¡¢addname¡¢location¡¢pp

×Ö¶ÎpicnameÄܲåÈëÊý¾Ý¡¢×Ö¶ÎlocationÒ ......

ASPÅжϵÄÎÊÌâ,ÓôÃÆÁË!Åжϲ»³öÀ´!

HTML code:

dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="& ......

Active Server Pages ´íÎó 'ASP 0113'

  Active  Server  Pages  ´íÎó  'ASP  0113'   
   
  ½Å±¾³¬Ê±   
   
  /admin/affiche_zx/i ......

asp:radiobttonÔõôÓÃ,ÓдúÂë.

ÏÂÃæÊÇÒ»¶ÎÒ³Ãæ´úÂë,Ò»¸öDATALISTÀïÃæÓÐRADIOBUTTON,Õâ¸ö¿Ø¼þÓ¦¸ÃÔõôÓð¡,ÎÒÒªµÄЧ¹ûÊÇ,´ÓDBÀï²é³öÀ´µÄÊý¾ÝÏÔʾÔÚDATALISTÖÐ,×îÇ°ÃæÒ»ÁÐÊÇRADIOBUTTON,¿ÉÒÔÑ¡ÖÐÆäÖÐÒ»ÐÐ.ÏÖÔÚµÄЧ¹ûÊÇ,¿ÉÒÔͬʱѡÖжàÐв¢Çҵò»µ½Ñ¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ