Hi Renier, You do this in DTML using the "fmt" attribute. For example if I had a datetime column... <dtml-var date fmt="%d/%m/%Y"> Michael -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Renier Leenders Sent: Tuesday, 3 September 2002 4:40 PM To: zope@zope.org Subject: [Zope] How to format database query? Hello there, I make a query in postgresql with: select * from table_name and i put it in html with: <dtml-in wet_query> <b> <dtml-var field1>.</b> <dtml-var field2> </dtml-in> field1 is a char field and field2 is a text field (column) How can i format this output? Is it possible in dtml or python? I think it must be possible with somekind of string manipulation but is don't know how to inplement it. Thanks for any help. _______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )