[thelist] trimming db output (was: ASP question: Req...)

[MRC]

matt and Anthony,

> >varFieldOne = Trim(objRS("FieldOne"))
> >
> >You save yourself from debugging hell when the data does not come out
> >"clean" from the DB.
>
> Be careful with this if your field can be NULL.

    SQL Server bench-warmer here, with a tip for avoiding the problem that
matt mentions while incorporating Anthony's suggestion:

varFieldOne = Trim(objRS("FieldOne") & "")

    This, of course, forces at least an empty string and avoids any
headaches from nulls. Comments? Counter-suggestions?

James Aylard