[Zope] How to format database query?

[Russell Hires]

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