[thelist] ASP help

Karen J. Bowen lists at miinx.com.au
Tue Sep 10 12:54:00 CDT 2002


Michael Robertson wrote:
> Lots of great tips here, thank you.
> Turns out the problem is related to the database. Using code below:
>
>  If objRs("SubText1") <> "" Or Not IsNull(objRs("SubText1")) Then
>  blnSub1=True
>  varSub1=objRs("SubText1")
>
> In some cases the column SubText1 is blank and in others is NULL. When the
> column is actually NULL the page displays fine, but if the column is just
> blank it displays the empty table. So it only sets blnSub1 to True is the
> columnm is NULL not if it's just blank.
>
> Suggestion?
>

Possibly your blank values are actually spaces (i.e. " ")...  try
checking the length of one.

HTH
Karen
-------
Miinx Design & Development
e :: karen at miinx.com.au
p :: 0413.880.302
w :: www.miinx.com.au





More information about the thelist mailing list