to check null value from database

[rk1_23]

Hi all
Can anyone help me
i need to check multiple rows in a msacess database at a time to check whether fields are null or not
i have used the following code but its not showing the exact result


if ( !rs.EOF && !rs.BOF )
{
while (!rs.EOF)
{
email = "" + rs.Fields("email");
name = "" + rs.Fields("name");
if(!(rs.Fields("email")))
{
okaddaccount = "true";
rs.MoveNext();
}
else
{
rs.Close();
rs = null;
Session("Error") = "please update profile";
Response.Redirect("account.asp?ID=" + Eno);
}
}
}

i also gave
if(!(rs.Fields("email") == null))
if(!(rs.Fields("email") == " ")) but no use

Thanks in Advance

[mattyblah]

are you using vbscript? try the function isnull(value). it returns a boolean whether the value is null or not.