in reply to Possible XML Question

Database to XML through XSLT to CSV sounds like a very roundabout way to achieve your ends. If your database does not support exporting directly to a CSV, then you could open one DBI connection to execute your query and open a second one to a file using DBD::CSV then loop through the result set doing inserts on the second connection.

Replies are listed 'Best First'.
Re: Re: Possible XML Question
by set_uk (Pilgrim) on Apr 09, 2003 at 12:02 UTC
    Its not as bad as it sounds - I am trying to achieve one select executed against the DB and then once I have the result set in XML I want to XSLT that to HTML or CSV depending on the situation. This way it minimises the database activity.