[thelist] Other ways to check for null

Casey aspnet at thecrookstons.com
Mon Nov 14 15:20:45 CST 2005


Nice catch indeed.  Thanks Mark.


> The logic is wrong here.
>
> You're basically saying (pseudocode):
>
> if rs("num_bedrooms") is not null  or "" then...
>
> It can't be both those things, so it's always going to evaluate as true 
> i.e.
> if it's null, then it's not ""
>
> You should be able to get away with a check for a zero length string to 
> make
> it simple.
>
> But really, the question should be, why is num_bedrooms not an integer, 
> and
> so why aren't you checking to see if it is >0?
>
> Hope this helps
>
> Mark 




More information about the thelist mailing list