<FontFamily><param>Courier New</param>Hi Arpad, All I also thought to this solution but in my zope application have to print the date with the month name not only with the month number (ideally). Finally I create a sql method with a 12 selects for each month but it is slow :) If I take your solution I should find a way to translate this month number in month name. I see to direction : 1/ If I can obtain the element i of the propriety list in my folder I win. But how select it, as simply in Python, this element? 2/ Create a Python class in the Zope Extension Folder with this translation capability. I try but had no succes (zope mailing list message :<color><param>0000,0000,8000</param>[Zope] - Sort date in gadfly/zope - Thu, 28 Jan 1999 17:50:57 +0100)</color> What do you thinks about? Thanks a lot, FR <color><param>0000,0000,0000</param><FontFamily><param>Arial</param>> Hi,
It is not clear for me why you don't use the ORDER BY clause in your SQL
statement.
Of course in this case you have to store month number instead of month name
in your Gadfly database(to provide the right order).
Cheers,
Arpad
François-Régis Chalaoux Bioinformatics Group Synthélabo Biomoléculaire 67080 Strasbourg Cedex FRANCE Tél : 03 88 60 87 14 Fax : 03 88 45 90 70