CourierHi All, FR Chalaoux wrote : As you know a gadfly database has no date type for the moment. Thus, as Aaron Watters recommanded, sort date is possible if you construct a date string with the format 'YY:MM:DD'(without quote). Paul Everitt wrote : Is it possible to construct this string date on the fly in an SQL method or is it an other solution? Yes, use the object-relational integration described at: 0000,8000,0000http://www.zope.org/Documentation/Guide s/ZSQL/ZSQL-HTML/ZSQL.html#pgfId- 936577 Basically, just write a Python class with a method that does what you want. ======================================= That's my resulting work : I did it on the Page 19 model from ZSQL.pdf file but it does not work :( ======================================= New External Method ======================================= < < <New External Method< < < < <

New External Method<

<
< < < < < < < < < < < << < < << < < < < <
Id<<<
<Title<<<<
Function name<<<
Python module file<<<
<<
<<
<
< < ======================================= Extension/datastring.py ======================================= class datastring: def datastring(self) """Create a new string composed with data from my gadfly table """ return year + ':' + month + ':' + day ======================================= Error ======================================= < < <exceptions.AttributeError< < < Sorry, an error occurred.<

< < < 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