ASP判断的问题,郁闷了!判断不出来!

[tcs533]

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不存在时
和应该是空的啊!
我这个怎么判断不出来啊!

[sy_binbin]

if jf=null then

[tcs533]

试过了!不行!

[yihunnanzi]

if jf=0 then

[z8h8y8]

if jf=0 then ?
if isnull(jf) then ?
if isempty(jf) then ?

[sy_binbin]

if isnull(jf) then


试试

[hookee]

<%
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").Value
if IsNull(jf) then
  response.write"<script>alert('你没有分数!');history.go(-1);</Script>"
  response.end
End If
%>

[joking520]

先 trim 后再判断。

[sumjor]

if IsNull(jf) then

[dangsz]

sum(cs)
出来的是0不是null

if jf="" then
改为
if jf=o then