31 May
2001
31 May
'01
3:32 p.m.
[Sebal]
BUT this one query#3 SELECT t1.ntheme , t1.valtheme <<<<<<<<<<<<<<<<<< FROM tabdef_theme AS t1 , tab_theme AS t2 WHERE t2.ndoc =<dtml-var numero_doc> AND t1.ntheme = t2.ntheme GROUP BY t1.valtheme ORDER BY t1.valtheme
I get: ...
/usr/local/Zope-2.3.1-linux2-x86/lib/python/Products/ZGadflyDA/gadfly/kjbuck ets0.py,
line 534, in __getitem__ KeyError: (see above)
I think it's an incorrect error message. I believe that the GROUP BY clause has to include all columns named in the SELECT clause. I doubt that the GROUP BY does anything for you anyway - it's only useful when you compute aggregate functions like AVG, SUM, etc. Get rid of it and rely on ORDER BY to organize your results. Cheers, Tom P