[thelist] ASP help

[Scott Dexter]

>
> > 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")

Why not check it in your SQL Statement? >=)

Select ISNULL(SubText1,"value to use if its null") as SubText1 ...

(MSSQL Server syntax above)


sgd