Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?

Re: XML::Generator::DBI Tutorial

by chanio (Priest)
on Apr 18, 2006 at 00:21 UTC ( #543956=note: print w/replies, xml ) Need Help??

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

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://543956]
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (6)
As of 2017-05-22 23:28 GMT
Find Nodes?
    Voting Booth?