Hi
I have a code that search on a table a record,
and i would like to use the if statement:
if rs("fname") = "cccc" then....else....
the problem is since my table doesn't have id=5, I get an error message "invalid use of null"
how can I solve it?
I have a code that search on a table a record,
Diff:
set rs=db.OpenRecordset("select fname from employee where id = 5" )
if rs("fname") = "cccc" then....else....
the problem is since my table doesn't have id=5, I get an error message "invalid use of null"
how can I solve it?