cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Berin Loritsch <>
Subject FW: SQL example = XML ? -> XSL
Date Wed, 01 Mar 2000 13:35:33 GMT

-----Original Message-----
From:	Berin Loritsch []
Sent:	Wednesday, March 01, 2000 8:35 AM
To:	''
Subject:	RE: SQL example = XML ? -> XSL

It is possible, but the limitation is that you need to know the tags being
generated by SQL producer.  (hint: its the column names of the table).
As long as you also include the processing instruction to use XSLT,
it will pass the results on.

There are some caveats, and it depends on what you need to do:

* The SQL producer is geared foward tables, each record contains
   a set of tags representing the answer.
* If you want to populate a form with the results, make sure your
   query returns 1 and only 1 record.

The SQL producer is a decent tool, and for quick and dirty uses, it
does the job.  XSP gives you finer grained control, and allows you
to separate content and logic more completely.

-----Original Message-----
From:	Wayne Elliott []
Sent:	Tuesday, February 29, 2000 8:39 PM
Subject:	SQL example = XML ? -> XSL

I managed to get the SQL example to work with some valid
DB parameters. This translates the query result to XML.

Is there a way to attach an XSL sheet to this so that I 
can both query and format the data.


Wayne Elliott                             |
ADI Limited                               | +61 8 9333 8889 (Fax)
C4ISR (IS3)                               | +61 8 9333 8888 (Ph)

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message