Skip to main content
Inspiring
June 16, 2008
Question

show if not null versus show if recordset is not empty

  • June 16, 2008
  • 3 replies
  • 472 views
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!
This topic is closed to new replies. Start a new post to keep the conversation going.

3 replies

Participating Frequently
June 17, 2008
yes i use that tool too its wicked
Inspiring
June 17, 2008
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
Inspiring
June 17, 2008
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