Op di 13 december 2011 om 15:35:14 (+0100) schreef rehs...@googlemail.com (Jens Rehsack): > 2011/10/4 Reinier Post <r...@win.tue.nl>: [...] > > 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
