Is there an easier way to check if any of the fields returned in a
select statement have null values?
After running this command:
set rs = conn.execute("select A,B,C,D,E,F,G,H,I,J from SomeTable
where...")
I could check each field this way:
If IsNull(rs("A") Then
Response.Write("The value of A is null")
Else
Response.Write("The value of A is " & rs("A"))
End If
If IsNull(rs("B") Then
Response.Write("The value of B is null")
Else
Response.Write("The value of B is " & rs("B"))
End If
If IsNull(rs("C") Then
Response.Write("The value of C is null")
Else
Response.Write("The value of C is " & rs("C"))
End If
etc.
But is there a simpler way?
Also, my "solution" probably wouldn't work if more than one recordset
was returned...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!