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µÄ£¬»¹ÐèÒªÄÜÔÚºǫ́¶ÔÐÅÏ¢½øÐÐÌíɾ¸Ä²éµÄ¡£Ð»Ð»¸÷λÁË¡£¡£¡£
³ÌÐòÕæµÄºÜ¶à£¬²»Öª ......
ÎÒÓÐÁ½¸ödropdownlist¶¼°óºÃÁËÖµ£¬ÏëÑ¡ÖÐÒ»¸ödropdownlistÖеÄÖµ£¬È»ºóÔÚÁíÒ»¸ödropdownlistÖÐÑ¡ÖÐÏàÓ¦µÄÒ»Ïî¡£
²»ÊÇ´Óа󶨵ڶþ¸ödropdownlist£¬ÊÇÔÚÒѾ°óºÃµÄÖµµ±ÖÐÑ¡ÖÐÒ»¸ö¡£
ÎÒÏëÓÃjsд
ÇóÖú
Äã¿ÉÒÔ°Ñdrop ......
SQL code:
rs.open "select * from guide where city_name='±±¾©' order by pai desc",conn,1,1
do while not rs.eof or rs.bof
¡£¡£
¡£¡£
¡£¡£
rs.movenext
loop
Õâ¸ösqlÓï¾äÔÚwapÕ¾Àï ±¾ÉíÓÐ ......
¹ØÓÚ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× ......
<table border= "0 " cellspacing= "0 " cellpadding= "0 ">
<BH_CHANNELS ID= "OWNER " CHILDTYPE= "aaa " ......