ÕâÊÀ½çÌ«¿ÉЦÁË£¡£¡£¡
ËÑË÷µÄÈ«²¿¶¼²»ÄÜÓã¬À´ÕâÀïÕÒÈ˽â¾ö·Ä×¢ÈëµÄÎÊÌ⣬ûÈËÄܸø¸öºÃʹµÄ·À×¢Èë´úÂ룿
ȷʵ¿ÉЦ,²»¹ý²»ÊÇÕâ¸öÊÀ½ç
<%
'--------¶¨Ò岿·Ý------------------
Dim Neeao_Application_Value
Dim Neeao_Post,Neeao_Get,Neeao_Inject,Neeao_Inject_Keyword,Neeao_Kill_IP, ......
Ö÷»ú
¿Í»§»úc1,c2,c3,c4,c5............
ÒªÇóÈçºÎ±£Ö¤¿Í»§»úÏòÖ÷»úÌá½»Êý¾Ý¾¡Á¿ÊµÊ±.¿ìËÙ.ÍêÕû
Ö±½ÓÓÃinsert ʱ,ËøסÖ÷»úµÄ±í.ËùÒÔ´Ë·½·¨²»¿ÉÐÐ
Çë¸ßÊÖÖ§ÕÐ..
Èç¹ûÖ»²åÈë¶ø²»¶Á£¬Óõ͸ôÀ뼶±ð
Äã²åÄãµÄ,Ëû²åËûµÄ,ËÒ²²»°Ë.
¹Ø¼üÔÚÓÚÄãµÄ·þÎñÆ÷µµ´ÎÊÇ·ñ¹»¸ß?
ѧϰ
SQL×Ô¼ºµÄËø»úÖÆÒѾ¹»ÓÃÁË
ÒýÓÃ
Äã²å ......
ÎÒ×öÁËÒ»¸öÍøÕ¾£¬ÆäÖÐʹÓÃÁËÒ»¸ö´æ´¢¹ý³Ì,ÏÂÃæµÄÊǵ÷Óô洢¹ý³ÌµÄ´úÂë
Set MyComm = CreateObject("ADODB.Command")
with MyComm
.ActiveConnection = cn 'MyConStrÊÇÊý¾Ý¿âÁ¬½Ó×Ö´®
.CommandText = "dt_user" 'Ö¸¶¨´æ´¢¹ý³ÌÃû
.CommandType = 4 '±íÃ÷ÕâÊÇÒ»¸ö´æ´¢ ......
Êý¾Ý¿â½á¹¹£º
id hit times
1 1 2008Äê2ÔÂ19ÈÕ
2 26 2008Äê2ÔÂ27ÈÕ
3 32 2008Äê2ÔÂ27ÈÕ
select sum(hit)as wk,times from hit where id=1005 group by times
µÃµ½½á¹û£º
1 2009Äê12ÔÂ10ÈÕ
2 2009Äê12ÔÂ16ÈÕ
1 2 ......
ÎÊÌâ¸ÅÊö£º
µç×ÓÉÌÎñÍøÕ¾£¬¼¯³ÉÁË¿ìÇ®µÄÖ§¸¶½Ó¿Ú
µ±Óû§´ÓÎÒÃÇÍøÕ¾·¢ÆðÖ§¸¶ÇëÇóµÄʱºò£¬Èç¹ûÖ§¸¶³É¹¦£¬¿ìÇ®»áͬʱGETºÍPOST¸øÎÒÃÇ·þÎñÆ÷Ö§¸¶³É¹¦µÄÐÅÏ¢
Ö±µ½ÎÒÃÇ·þÎñÆ÷ÏìÓ¦ÊÕµ½ÎªÖ¹£¬È»ºóÎÒÃÇÍøÕ¾¼Ç¼´ËÈ˵IJÆÎñÃ÷ϸ¡£
µ«ÊÇÓÐÒ»¸öÎÊÌ⣬ºÜÉÙºÜÉÙµÄÇé¿öÏ£¬ÎÒÃÇÍøÕ¾µÄ³ÌÐò»á¶à¸øÓû§ÔÚÎÒÃÇÍøÕ¾µÄ²ÆÎñÕʺÅÀï¶ ......
ÏÂÃæÊǼÆË㵱ǰ»ý·ÖµÄsqlÓï¾ä£ºÈç¹û¼Ç¼ΪnullʱÏÔʾ0
select isnull('0',(b.sumpoints - a.usedpoints)) as points
½á¹û£ºËùÓмǼ¶¼ÏÔʾ 0
Èç¹û£º
select (b.sumpoints - a.usedpoints) as points
È´³öÏÖnull
ÇëÎÊÔõÑù½«ÕâЩnull±ä³É0ÄØ£¿
select isnull((b.sumpoints - a.usedpo ......