in reply to XML::Generator::DBI Tutorial

Thank you for this 'XML in perl show'. It is even more useful as a working example of integrating xml-sax in perl than as it's main purpose in this tutorial.

In order to preserve coherence with your first DBI example: at your third example you should correct the following:

$generator->execute('select foo as td,bar as td from baz');
Should be...
$generator->execute('select bar as td,baz as td from foo');
...and the output should read:
<table query="select bar as td,bas as td from foo"> <tr> <td>one</td> <td>1</td> </tr> <tr> <td>two</td> <td>2</td> </tr> <tr> <td>three</td> <td>3</td> </tr> </table>
intead of...
<table query="select foo as td,bar as td from baz"> <tr> <td>foo</td> <td>1</td> </tr> <tr> <td>bar</td> <td>2</td> </tr> <tr> <td>baz</td> <td>3</td> </tr> </table>
Am I wrong?

And, finally, if I understand your worries...

... Also, example 5 has a couple of known bugs: ... Also, opening and close <html> and <body> tags are generated when they too are not needed...
Should happen because your previous dynamic.xsl stylesheet has the <html> and <body> tags mentioned...

I hope that I have really :) contributed with this extraordinary tutorial. Thank you a lot!

Replies are listed 'Best First'.
Re^2: XML::Generator::DBI Tutorial
by sandeepb (Novice) on Jul 21, 2015 at 10:30 UTC
    Simple script to convert CSV file into XML file