[thelist] ASP help

[lon.kraemer]

> 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.

Two ways to go here:

If objRs("SubText1") <> "" AND Not IsNull(objRs("SubText1")) Then
blnSub1=True
varSub1=objRs("SubText1")

If objRs("SubText1") = "" OR IsNull(objRs("SubText1")) Then
else
blnSub1=True
varSub1=objRs("SubText1")

--
Lon Kraemer
-----------------------------------------