Catch Nulls and blanks?

[jason]

How does one accurately catch NULL or blank fields in ASP....it appears this
If statement does not appear to be able to catch it...why is this...I appear
to have covered all the necessary conditions but it does not seem able to
pick it up:

If IsNull(Owner_ID) or Owner_ID="" or IsEmpty(Owner_ID) or Owner_ID = Null
Then

Response.Write "A null value has been picked up in the Owner_ID field"

End If

[Ray at]

If don't care about NULL vs. empty, you can do:

Owner_ID = YourRecordSet.Fields.item("whatever").Value & ""
If Owner_ID = "" Then Response.Write "The value is null or empty."

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl...

How does one accurately catch NULL or blank fields in ASP....it appears this If statement does not appear to be able to catch it...why is this...I appear to have covered all the necessary conditions but it does not seem able to
pick it up:

If IsNull(Owner_ID) or Owner_ID="" or IsEmpty(Owner_ID) or Owner_ID = Null
Then

Response.Write "A null value has been picked up in the Owner_ID field"

End If

[Randy Rahbar]

> How does one accurately catch NULL or blank fields in ASP....it appears
this

I usually test for length...

if len(yourVariable) > 0 then
'it's not null or blank
else
'it is
end if

[Randy Rahbar]

> if len(yourVariable) > 0 then

This should probably be...
if len(trim(yourVariable)) > 0 then

[jason]

Thanks.
"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message
news:eb**************@tk2msftngp13.phx.gbl...

If don't care about NULL vs. empty, you can do:

Owner_ID = YourRecordSet.Fields.item("whatever").Value & ""
If Owner_ID = "" Then Response.Write "The value is null or empty."

Ray at work

"jason" <ja***@catamaranco.com> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl...

How does one accurately catch NULL or blank fields in ASP....it appears

this

If statement does not appear to be able to catch it...why is this...I

appear

to have covered all the necessary conditions but it does not seem able to pick it up:

If IsNull(Owner_ID) or Owner_ID="" or IsEmpty(Owner_ID) or Owner_ID = Null Then

Response.Write "A null value has been picked up in the Owner_ID field"

End If

[jason]

Thanks.

"Randy Rahbar" <rvrahbar@_JUNK_hotmail.com> wrote in message
news:uC*************@tk2msftngp13.phx.gbl...

if len(yourVariable) > 0 then

This should probably be...
if len(trim(yourVariable)) > 0 then

[Venkat]

You can user one more property provided in VB and VB Script i.e.,
vbNullString and then try.

If IsNull(ColumnName) Or ColumnName <> "" Or ColumnName <> vbNullString
Then
Do Something
End If

DEVBuilder.org, http://www.DEVBuilder.org
ASP,ASP.NET,VB.NET,PHP,Java,and SQL Support, all in one place.

[Steven Burn]

If Len(Owner_ID) = 0 Then
'Do something
Else
'Do something else
End If

--

Regards

Steven Burn
Ur I.T. Mate Group
www.it-mate.co.uk

Keeping it FREE!

Disclaimer:
I know I'm probably wrong, I just like taking part ;o)
jason <ja***@catamaranco.com> wrote in message
news:Oi**************@tk2msftngp13.phx.gbl...

How does one accurately catch NULL or blank fields in ASP....it appears this If statement does not appear to be able to catch it...why is this...I appear to have covered all the necessary conditions but it does not seem able to
pick it up:

If IsNull(Owner_ID) or Owner_ID="" or IsEmpty(Owner_ID) or Owner_ID = Null
Then

Response.Write "A null value has been picked up in the Owner_ID field"

End If