Beefy Boxes and Bandwidth Generously Provided by pair Networks
Just another Perl shrine
 
PerlMonks  

Re: Possible XML Question

by grantm (Parson)
on Apr 08, 2003 at 23:10 UTC ( [id://249117]=note: print w/replies, xml ) Need Help??


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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://249117]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2024-04-23 07:31 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found