-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 First, it would be a better idea to ask on the zope-db@zope.org mailing list. Second, there are specific dtml tags for dealing with sql, to make sure that people aren't able to enter things like "delete" or "update" as arbitrary strings. <dtml-sqlvar field1 type=string optional> is an example of what you want. Check the zope-db list archives or check the zope book for more information on this! Russell

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

Linux -- the OS for the Renaissance Man -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9dKFMAqKGrvVshJQRAutjAKCv/mS2XNn0mJsnqVu0GDRjUqJ8zgCcCR0A 3Pkdqifc+jyjFLXumeUUGYk= =rvHf -----END PGP SIGNATURE-----