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

Anthony Baratta Anthony at Baratta.com
Thu Nov 29 14:05:06 CST 2001


At 11:48 AM 11/29/2001, you wrote:
> >
> > True, if you are interested in the value "NULL". This would
> > destroy that.
>
>no, it would cause a type mismatch error, so you gotta take it into
>account and work around it.

Strange, I've never had that problem. Of course now it will crop up! LOL

But using the isNull SQL Function is a total solution anyway. At work, I 
usually am the one to harp on "let the database do the work", but I miss 
stuff like this because most of my SQL needs are very basic.

Burning this solution into the grey matter for later use.
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."





More information about the thelist mailing list