Re: 3vl 2vl and NULL

From: dawn <dawnwolthuis_at_gmail.com>
Date: 6 Dec 2005 08:31:41 -0800
Message-ID: <1133886700.967610.279320@g14g2000cwa.googlegroups.com>

David Cressey wrote:
> "dawn" <dawnwolthuis_at_gmail.com> wrote in message
> news:1133834551.860204.241810_at_g44g2000cwa.googlegroups.com...
>
>
> > You know, Jonathan, those U2 folks work for the same company as you --
> > you could check with them how they handle a 2VL as I'm sure they know
> > better than I how it is implemented. I only know that it works fine
> > until I have to figure out how to combine SQL with it. The best I've
> > done is pass nulls in numeric fields to SQL as if they were zero,
> > which, of course, skews averages quite badly.
>
> Don't pass them. Filter them out.

I am referring to installing a SQL wrapper where you do want users to have access to all data (and known when there is a lack thereof) for their queries. --dawn Received on Tue Dec 06 2005 - 10:31:41 CST