Re: 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');
[download]

Should be...

$generator->execute('select bar as td,baz as td from foo');
[download]

...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>
[download]

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>
[download]

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!

Landlords production is only eaten by landlords...
Wherever I lay my KNOPPIX disk, a new FREE LINUX nation could be established

Comment on Re: XML::Generator::DBI Tutorial Select or Download Code

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 http://exceptiongeek.com/articles/article/6/Convert-CSV-file-into-XML-file-in-Perl

[reply]


Pathologically Eclectic Rubbish Lister
	PerlMonks