ASPÅжϵÄÎÊÌâ,ÓôÃÆÁË!Åжϲ»³öÀ´!
HTML code:
dim jf
set conn=server.createobject("adodb.connection")
connstr="Driver={Sql Server};Server="&Sqlip&";Database="&Sqldb&";Uid="&SqlUid&";Pwd="&SqlPwd&";"
conn.Open connstr
Set RS=Conn.Execute("SELECT sum(cs) as ok from aaa WHERE (bbb='abc')")
jf=rs("ok")
if jf="" then
response.write"<script>alert('ÄãûÓзÖÊý!');history.go(-1);</Script>"
response.end
End If
µ±¼Ç¼Àïabc²»´æÔÚʱ
ºÍÓ¦¸ÃÊǿյİ¡!
ÎÒÕâ¸öÔõôÅжϲ»³öÀ´°¡!
if jf=null then
ÊÔ¹ýÁË!²»ÐÐ!
if jf=0 then
if jf=0 then ?
if isnull(jf) then ?
if isempty(jf) then ?
if isnull(jf) then
ÊÔÊÔ
ÏÈ trim ºóÔÙÅжϡ£
sum(cs)
³öÀ´µÄÊÇ0²»ÊÇnull
if jf="" then
¸ÄΪ
if jf=o then
if IsNull(jf) then
Ïà¹ØÎÊ´ð£º
http://www.zgjhjy.com/Test/PrimaryTest/Index.aspx
¾ÍÊÇÀàËÆÒÔÉϵÄÔÚÏß²âÊÔϵͳ£¬ÐèÒªÓÐÒ»¸öºǫ́µÄ£¬ÓïÑÔÊÇaspµÄ£¬Êý¾Ý¿âÊÇaccessµÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£
³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......
´ó¼ÒºÃ!ÎÒÊÇÒ»¸öѧÉú,ÏÖÔÚÊÇѧASPµÄ²»ÖªµÀÔõô»ØÊÂ,ÎÒ×Ô¼ºÊÇÓÃCMS×ö¹ýÍøÕ¾ ´úÂëÒ²ÄÜ¿´¶®Ò»µã ÏÖÔÚÏëÂò±¾Êé,Ïë·¨Óкܶà,¾ÍÊÇÏëÂòASPµÄ ÓÖ¿´µ½´ó¼Ò˵ASPÒÔºóûÓÐNETǰ¾°ºÃ,ÎÒÓÖÏëÔÙÈ¥Âò±¾ASP.NETµÄ ÎÒÖªµÀÓÐÕâÑùµÄÏë·¨ ......
¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡
ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º
sql×¢Èë©¶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´
³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿
×¢Èë©¶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹
±©¿â©¶´Ôõô·ÀÖ¹
»¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif
ÕâÖÖ©¶´Ôõôȥ± ......
<tr>
<td width="700" valign="top" align="left">
<!--¼ÓÔØÊý¾Ý¿â²úÆ·Áбí°üº¬·ÖÒ³´úÂ뿪ʼ -->
<tabl ......
¹ØÓÚasp.net md5 32λ¼ÓÃܽâÃÜ
ÓÐûÓÐÈË¿ÉÒÔд¸öÀà¡£
²¢Ïêϸ½âÊÍһϣ¬±¾È˺ܲ»Àí½â32λmd5
C# code:
public string md5(string str,int code)
2{
3 if(code==16) //16λMD5¼ÓÃÜ£¨È¡32λ¼ÓÃܵÄ9~25× ......