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
Ïà¹ØÎÊ´ð£º
function CheckOpwd(){//ÑéÖ¤Óû§Ãû
var pwd=document.all.txtOpwd;
var div1=document.getElementById("divPwd");
if (pwd.value=="")
{
......
aspÐéÄâÖ÷»úʵÏÖα¾²Ì¬µÄ·½·¨£º
1¡¢ ÖØдurl²ÎÊý
Step1: ½¨Á¢Ç°Ì¨Îļþindex.asp£¬ÐÞ¸Äurl²ÎÊýÐÎʽ¡£ÓÉÓÚ¶ÁÈ¡Êý¾Ý¿âÖеļǼ²»ÊÇרÌâµÄÖص㣬¹ÊÖ±½Ó¸ø³ö:
<!--#include file="config.asp" -->
&l ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
Microsoft JET Database Engine '80040e07'
±ê×¼±í´ïʽÖÐÊý¾ÝÀàÐͲ»Æ¥Åä¡£
\wwwroot\update.asp, line 20
--------------------------------------------------------------------------------
Ho ......
¹ØÓÚÍøÕ¾°²È«µÄÎÊÌ⣡
ÎÒÁ˽⵽µÄÍøÕ¾°²È«ÎÊÌâ°üÀ¨£º
sql×¢È멶´ºÍ±©¿â©¶´»¹ÓÐÉÏ´«Â©¶´
³ýÁËÕâЩ»¹ÓÐÆäËûµÄ©¶´Ã´£¿
×¢È멶´¿ÉÒÔͨ¹ý¹ýÂËÀ´·ÀÖ¹
±©¿â©¶´Ôõô·ÀÖ¹
»¹ÓÐÈËÉÏ´«µÄľÂíÊÇ.gif
ÕâÖÖ©¶´Ôõôȥ± ......