[Zope-DB] ZPT SQL newbie question
charlie at begeistert.org
Fri Sep 19 06:13:44 EDT 2003
On 2003-09-19 at 01:56:23 [+0200], Ray Kimsey wrote:
> Does anyone know how to achieve this sort of "group by" effect ?
> Part two is how to set the initiative argument to the ZSQL method (above
> it is hard coded to 'ssf') to the string value of here/id.
You need to run two queries to achieve this result or maybe one query in a
PythonScript with some processing.
Your first query would GROUP BY focus_area, the second query would provide
the individual results within the group.
More information about the Zope-DB