Renier Leenders writes:
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. How do you want to format the result?
Usually, you would use HTML to format the result of Z SQL Methods. Look at "Z Search Interface" (in your "Add" list), for an example. Only, when you want to format material *inside* a result column, you need Zope help. But, you need to tell us, how you want to format this. On possibility is the "newline_to_br" attribute to "dtml-var". It converts newslines to <br> and thus provides for some form of formatting. Another is 'fmt="structured-text"'. It converts structured text into HTML. I suggest, you look at some example in the Zope Book... Dieter