[Zope-DB] ZPT SQL newbie question

Charlie Clark 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.

Charlie



More information about the Zope-DB mailing list