From: "James Britt (rubydev)" <james@...>
Date: 2001-11-01T23:03:10+09:00
Subject: [ruby-talk:24080] Re: rubyxml.com article on REXML with MySQL

Thanks!  I'll take a look; hadn't heard of it before.


James


> -----Original Message-----
> From: Michael Neumann [mailto:neumann@s-direktnet.de]
> Sent: Thursday, November 01, 2001 3:45 AM
> To: ruby-talk ML
> Subject: [ruby-talk:24072] Re: rubyxml.com article on REXML with MySQL
> Importance: High
> 
> 
> James Britt (rubydev) wrote:
> > I've written an article about using REXML (Ruby Electric XML) with MySQL:
> > http://www.rubyxml.com/articles/REXML/MySQL_and_REXML
> 
> Nice article.
> 
> You may have a look at Ruby/DBI's module XMLFormatter. It lets you 
> easily create XML documents from a SQL query:
> 
> DBI.connect(...) do | dbh |
>   rows = dbh.select_all("SELECT * FROM ....")  
>   DBI::Utils::XMLFormatter.table(rows, "rows", "row", $stdout)
>   # there is more fine grained control with 
>   # methods row and extended_row
> end
> 
> Regards,
> 
>   Michael
> 
> -- 
> Michael Neumann
> merlin.zwo InfoDesign GmbH
> http://www.merlin-zwo.de
>