[thelist] ASP help

[Anthony Baratta]

At 10:35 AM 9/10/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")

Try this...

if (CheckNull(objRS("SubText1"))) then
         blnSub1=True
         varSub1 = Trim(objRS("SubText1"))
end if

''''''''''''''''''''''''''''''''''''''''''''''''''
'' CheckNull Function
'' Required Info Passed to Function:
''      varString
''''''''''''''''''''''''''''''''''''''''''''''''''
Function CheckNull(varString)
     if not(Trim(varString) = "" or isNull(Trim(varString))) then
                 CheckNull = False
     else
         CheckNull = True
     end if
End Function



---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."