From: "Berger, Daniel" <Daniel.Berger@...>
Date: 2006-05-30T23:49:00+09:00
Subject: Re: (DBI::Utils::XMLFormatter) Output results as a string?

> -----Original Message-----
> From: x1 [mailto:caldridge@gmail.com] 
> Sent: Monday, May 29, 2006 3:39 PM
> To: ruby-talk ML
> Subject: Re: (DBI::Utils::XMLFormatter) Output results as a string?
> 
> 
> I never could get it to work properly... It's like.. when I 
> used the fourth variable as you suggested, the <rows> 
> component was missing.
> 
> IE:
> 
> irb> DBI::Utils::XMLFormatter.table(dbh.select_all("SELECT *
> FROM people"), nil, nil, asdf)
> 
> puts asdf
> 
> <>
> <row>
>    <yada>
>    </yada>
> </row>
> </>

Try this:

DBI::Utils::XMLFormatter.table(
   dbh.select_all("select * from people"), 'rows', 'row', asdf)
)

The actual definition looks like this:

XMLFormatter.table(rows, roottag = "rows", rowtag = "row",
output=STDOUT)

HTH,

Dan


This communication is the property of Qwest and may contain confidential or
privileged information. Unauthorized use of this communication is strictly 
prohibited and may be unlawful.  If you have received this communication 
in error, please immediately notify the sender by reply e-mail and destroy 
all copies of the communication and any attachments.