[Zope] Date/Time - DTML - SQL question

FR Chalaoux chalaouxf@synbio.tpgnet.net
Mon, 15 Feb 1999 12:47:36 +0100


<color><param>0100,0100,0100</param>Hi All,


In the following sql method I select records with 'date' (a float field) 
superior to an 'dayfloatdate' float field. 'dayfloatdate' is just the date=
 
of the day in the float fomat (i.e. 19990215.0)


How is it possible to construct '</color><FontFamily><param>Times New Roma=
n</param><bigger>dayfloatdate' before sqlmethod 
call cause construct 'dayfloatdate' in the sql method seems 
difficult for me :)<color><param>0100,0100,0100</param><FontFamily><param>=
Arial</param><smaller>



-----------------------

SQL method

-----------------------

<FontFamily><param>Times New Roman</param><bigger>select * from table wher=
e date > <<!--#var dayfloatdate-->



Bye, FR.<FontFamily><param>Arial</param><smaller>

Fran=E7ois-R=E9gis Chalaoux
Bioinformatics Group
Synth=E9labo Biomol=E9culaire
67080 Strasbourg Cedex
FRANCE
T=E9l : 03 88 60 87 14
Fax : 03 88 45 90 70