I'm trying to fix: #6334 Open Bug Medium 1.7 Taglibs Cannot specify fields on listcontainer tag
Which of course has to do with using 'distinct' on mm:list, and making it a bit reasonable. I thinkt the trouble with aggregated fields it that they are always associated with one field. Therefore count queries an arbitrary field: SELECT COUNT(news.number) AS number FROM mm_news news,mm_insrel insrel,mm_urls urls WHERE news.number IN (396) AND (news.number=insrel.snumber AND urls.number=insrel.dnumber) That's ok for counts (though you would expect COUNT(*)) but for COUNT(DISTINCT it's a bit unfortunate. SELECT COUNT(DISTINCT news.number) AS number FROM mm_news news,mm_insrel insrel,mm_urls urls WHERE news.number IN (396) AND (news.number=insrel.snumber AND urls.number=insrel can be something different then SELECT COUNT(DISTINCT news.number,urls.number) AS number FROM mm_news news,mm_insrel insrel,mm_urls urls WHERE news.number IN (396) AND (news.number=insrel.snumber AND urls.number=insrel but I do not think this last query can be made with the SearchQuery frame work. Btw, I just discoved that also my postgresql 7.3 chokes in this last syntax (how silly), but mysql has no problems. Michiel -- Michiel Meeuwissen Mediapark C101 Hilversum +31 (0)35 6772979 nl_NL eo_XX en_US mihxil' [] ()
