Cart
[Home] [By Thread] [By Date] [Recent Entries]
At 04:50 PM 12/2/2003 +0530, karthikeyan.balasubramanian wrote: Just wondering if we can get data in mysql as an xml and use xslt to format it. I'm in the middle of doing this, myself. Assuming you're using Linux, if you go to the command line and type: mysqldump -X --password='YOUR_PASSWORD' DATABASE_NAME >XML_FILE.xml ...you'll get an XML data file in the format: <database name="DATABASE_NAME">
<table name="TABLE_NAME>
<row>
<field name="FIELD_NAME">FIELD_DATA</field>
...more fields...
</row>
...more rows...
</table>
...more tables...
</database>I have some XSLT files designed to strip out data from that format. Drop me a private email if you'd like them, and I'll ship them off. I haven't done any work to format them yet. XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
