[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