show if not null versus show if recordset is not empty

[aonefun]

I am familiar with the "show if recordset is not empty" server behavior. Is there a comparable server behavior or extension that would provide a "show if database field is not null" effect? I am hand coding the asp to achieve this but am wondering if there is a quick solution.
thanks!

[MikeL7]

Not that i know of, but sounds like you know about IsNull
Dim sVal
sVal = Null
If IsNull(sVal) Then
response.write("Its Null")
End IF

[Newsgroup_User]

aonefun wrote:
> I am familiar with the "show if recordset is not empty" server behavior. Is
> there a comparable server behavior or extension that would provide a "show if
> database field is not null" effect? I am hand coding the asp to achieve this
> but am wondering if there is a quick solution.
> thanks!
>

I use the Advanced Conditional Region extension from DMXzone.com for
this all the time: http://www.dmxzone.com/showDetail.asp?TypeId=3&NewsId=553

Steve

[kiss4me08]

yes i use that tool too its wicked