I have this rsCustomer executing on a page, and I want to find an easyway of checking if any of the fields are empty or Null. at the moment I am using If IsNull(rsCustomer("fieldname)) then but there must be a better way, cause I want to redirect them to update profile page.

any good ideeas?

Hi there,

I am not sure I understand the problem. What does the IsNull have to do with a Redirect statement? What can't you redirect when the column IsNull (or isn't) and why do you need a better alternative for IsNull?

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

the database has been on the server for more than 3 years.
the entire website is getting redone and more than 10 new fields has been added to the customer table.

if a customer comes back to the website, all the new fileds added have empty value, so i need to redirect them to the update details page. As I said I could do it by checking the field for null value, but i thought is a cleaner way of doing it, instead typing 20 lines of code.

Well, I don't think so. You have to check out whether the field contains Null to find out whether it contains null ;)

Instead of 10 redirect statements, you could query the database for the null fields. Something like this:

SELECT Count(ID) FROM Customer WHERE Field1 = Null OR Field2= Null WHERE Customer.ID = 1234

If this query returns a record, some of the new fields was null so you need to redirect.

Does this help?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

No, that's not good, as i don't want to query the database again. all fields are already filter and written to the browser, so another call to the database is out of discussion.

i'll stick to my statement:

if IsNull(rsCustomer("LastName")) or IsNull(rsCustomer("FirstName")or...and so on... then
response.redirect("updatepage.asp")

Thanks anyway.