[Zope-DB] select max()
a.meyer at hccnet.nl
Thu Oct 16 11:56:33 EDT 2003
Dear Gadfly specialists
While trying to build a simple music database I have the following problem:
In a DTML Method I use this code:
id is <dtml-var id> <br>
all_composers is a ZSQL Method: select * from composer
This returns the list of ids.
However, now I want to retrieve the maximum index and add the ZSQL
Method max_composer_id: select max(id) from composer.
The query works, but when I replace the call in the DTML text I do not
receive the integer in the result, but the string 'composer'. What is
thanks for any help
More information about the Zope-DB