Re: Database/DBD Bridging?

Op di 13 december 2011 om 15:35:14 (+0100) schreef [email protected] (Jens Rehsack):
> 2011/10/4 Reinier Post <[email protected]>:
[...]
> > For instance, I have a simple script that needs to count the number of
> > distinct values in columns.  This seems like a pretty elementary thing
> > to do, but after a lot of tweaking and tinkering I've found that
> >
> >  - SELECT COUNT(DISTINCT) ... is invalid in Jet (Access MDB)
> >  - SELECT COUNT(*) FROM (SELECT DISTINCT ...)) is invalid elsewhere
> >  - SELECT DISTINCT ... is accepted but just does SELECT in DBD::CSV
> 
> How old are you're DBD::CSV / SQL::Statement versions?
> Of course, SELECT DISTINCT works well in DBD::CSV.

Indeed, SELECT DISTINCT appears to work just fine now,
and I can't recall the conditions under which it appeared to fail,
so feel free to attribute it to faulty testing on my part.

> /Jens

-- 
Reinier