[Zope] How to format database query?

Michael Fox Michael@CenturySoftware.com.au
Tue, 3 Sep 2002 16:43:37 +1000


Hi Renier,

You do this in DTML using the "fmt" attribute. For example if I had a
datetime column...

<dtml-var date fmt=3D"%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=20
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 -=20
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope-dev )