[Zope-DB] select max()

[Bo M. Maryniuck]

On Thursday 16 October 2003 17:56, Andre Meyer wrote:
> Dear Gadfly specialists
>
> While trying to build a simple music database I have the following problem:

[...]

First of all: if Gadfly is enough for you needs, therefore you really don't 
want use it. Because you can do everything (and much better) in pure ZODB 
with objects and BTreeFolder2 or even OrderedFolder or even simple Folder.
Gadfly is to teach very young children what SQL principle is.

Second: NEVER-NEVER-NEVER use "*" (asterisk) SQL's to select stuff from ANY of 
exiting DB over the Earth. This is very bad.

Third: you probably want to define types, like:  "foo:string", "bar:int" etc 
in your template. Zope Book at zope.org is your friend.

-- 
Regards, Bogdan

A computer without any MS Windows is like a fish without a bicycle.
		-- With apologies to Gloria Steinem