[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