(DBI::Utils::XMLFormatter) Output results as a string?

ruby-talk
1

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.

···

-----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:

> DBI::Utils::XMLFormatter.table(dbh.select_all("SELECT *
FROM people"), nil, nil, asdf)

puts asdf

<>
<row>
   <yada>
   </yada>
</row>
</>

2

I'll check it out tomorrow and let you know.

Thanks again Dan and sorry for the late response :slight_smile:

···

On 5/30/06, Berger, Daniel <Daniel.Berger@qwest.com> wrote:

> -----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:
>
> > 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.

3

Worked like a champ. Thank you!!

···

On 6/7/06, x1 <caldridge@gmail.com> wrote:

I'll check it out tomorrow and let you know.

Thanks again Dan and sorry for the late response :slight_smile:

On 5/30/06, Berger, Daniel <Daniel.Berger@qwest.com> wrote:
> > -----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:
> >
> > > 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.
>