cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <ba...@webslingerZ.com>
Subject Re: [C1.8.2] ESQL question <esql:get-columns/> in particular
Date Mon, 05 Feb 2001 23:17:15 GMT
On Tue, 6 Feb 2001, Frank Ridderbusch wrote:

> Hi folks,
>
> I'm doing my first steps with Cocoon and esql and I'm trying to port
> something I created with Oracles xsql utility to esql.
>
> I'm retrieving the results of the query with the <esql:get-columns/>
> tag.
>
> First of all I would like to ask, how I can achieve a more vertical
> formating of the resulting xml. Instead of
>
> <rowset>
>   <row><col1>...</col1><col2>...</col2><col3>...</col3>...</row>
> </rowset>
>
> I would like
>
> <rowset>
>   <row>
>     <col1>...</col1>
>     <col2>...</col2>
>     <col3>...</col3>
>     ...
>   </row>
> </rowset>
>
> I simply find the more vertical format easier on the eye, when I'm in
> the need to directly look at the XML.

look at the formatter options in cocoon.properties.

> Second, I like to ask, how I can suppress null columns? For instance,
> my query returns 27 columns and sometime more than half of them are
> empty. After the XSL transformation I alway see 'null' in the
> resulting HTML.  I tried to suppress the null columns at the XSL
> stage, but was unsuccessful.
>
> The XSQl utility (servlet) from Oracle works this way. Only non empty
> columns produce any XML nodes, empty columns are suppressed by
> default.

what do folks think? should we suppress null columns by default?

- donald


Mime
View raw message