isnull and blank with if/then statement

[phoenixaz]

I have 10 fields that I want to check if they are both null or blank. Is there an easy way to do that?

I have been using something like this..

if isnull (objrs ("field1")) and isnull (objrs ("field 2")) and isnull (objrs ("field3")) ......isnull (objrs ("field10")) then
'something

This doesn't check for objrs ("field1") = "" and objrs ("field2") = "" etc.....

So is there a way to combine isnull and blank and not have to list all of them like above.

Thanks for your help.

[KLynch0803]

I use this on my forms

' Form validation vars
dim errorsontheform(10)
dim formerrors(12)
formerrors(0) = "Need Frist Name"
formerrors(1) = "Need Last Name"
formerrors(2) = "Need Address"
formerrors(3) = "Need City"
formerrors(4) = "Need State"
formerrors(5) = "Need Zipcode"
formerrors(6) = "Need Phone"
formerrors(7) = "Need Email"
formerrors(8) = "Need Fence Style"
formerrors(9) = "Need Lead Time"
formerrors(10) = "Need Comments"
' This flags an error in data entry
formerrors(11) = 0



if request.form("submit") <> "" then
	for i = 0 to 10
		getthisform = thisformname & i
		formvalues(i) = request.form(getthisform)
	next
	ValidateForm
	if formerrors(11) = 0 then
	response.redirect("http://YOURSITE/Confirm.asp")	
	end if
	Session("FirstPass") = "no"
	Session("ThisForm") = formvalues
end if

[sqlconfused]

if objrs("field1") & "" = "" then response.write "is null or blank"

[gk53]

the simple solution is

if trim(objrs ("field1") & " ")="" then
response.write "empty field"
end if

[phoenixaz]

So are you saying that this code covers both null and blank?
if trim(objrs ("field1") & " ")="" then

If the answer is yes, then back to the original question about not having to repeat the code below. Is there an easier way rather than having to list each one? Can you do a between Field1 - Field2:

if isnull (objrs ("FIELD1")) or objrs("FIELD1") = ""  and isnull (objrs ("FIELD2")) or objrs("FIELD2") = ""   and isnull (objrs ("FIELD3")) or objrs("FIELD3") = ""   and isnull (objrs ("FIELD4")) or objrs("FIELD4") = ""   and isnull (objrs ("FIELD5")) or objrs("FIELD5") = ""   and isnull (objrs ("FIELD6"))  or objrs("FIELD6") = ""  and isnull (objrs ("FIELD7")) or objrs("FIELD7") = ""  and isnull (objrs ("FIELD8")) or objrs("FIELD8") = ""  and isnull (objrs ("FIELD9")) or objrs("FIELD9") = ""  and isnull (objrs ("FIELD10"))  or objrs("FIELD10") = ""  then

[gk53]

Yes. It is covers both
if you want all in one statement you can do something like

if trim(objrs("field1") & objrs("field2") &  objrs("field3") & objrs("field4") & objrs("field5") & objrs("field6") & objrs("field7") & objrs("field8") & objrs("field9") & objrs("field10") & " " )="" then
response.write "All fields empty"
end if

or

for i=1 to 10
fldname="field" & i
if trim(objrs(fldname) & " ")="" then
response.write "missing value in field" & i & "<br>"
end if
next

[phoenixaz]

Thank you for that! Both of those do the job more efficiently that my code.

I appreciate your time.

[sqlconfused]

The simple solution is to just add double quotes. Adding a space and then trimming it is the same result as what I spoted. Why complicate things?

if objrs("field1") & objrs("field2") &  objrs("field3") & objrs("field4") & objrs("field5") & objrs("field6") & objrs("field7") & objrs("field8") & objrs("field9") & objrs("field10") & "" ="" then
response.write "All fields empty"
end if

[phoenixaz]

Thanks for your input, I appreciate it.