这段代码为什么不好使那?
<% set rs=server.createobject( "adodb.recordset ")
sql= "SELECT SUM(zongji)-SUM(xiaofei) AS h FROM zijin where name= ' "&Session( "UserId ")& " ' "
rs.open sql,conn,3,2
dim a
a=rs( "h ")
if a <100 then
response.write " <script> alert( '余额不足！ ');location.href = 'login.asp '; </Script> "
response.end
end if
rs.close
set rs=nothing%>

就是想判断当A小于100时,弹出提示.

但是 我写的不对 高手看看我写错哪啦!

问题多,分给的少点,别介意啊,解决了立刻结帖!


[解决办法]
sql= "SELECT SUM(zongji)AS g, SUM(xiaofei) AS h FROM zijin where name= ' "&Session( "UserId ")& " ' "
a=rs( "g ")-rs( "h ")

[解决办法]
sql= "SELECT (SUM(zongji)-SUM(xiaofei)) AS h FROM zijin where name= ' "&Session( "UserId ")& " ' "
[解决办法]
不知道你提示什么错误

上面写了2个可能

你在看下 if cint(a) < 100 then
[解决办法]
定义字段的时候默认值设为0