In that case using Data::Dumper is quite nice for figuring those types
of things out.
Robert wrote:
On 5/9/05 9:39 PM, in article
[EMAIL PROTECTED], "Ian
Harisay" <[EMAIL PROTECTED]> wrote:
This is really off topic.
Not so. I was more interested in how the fetchrow_arrayref works (or wasn
You were right Amy...I guess I was OT after all.
Robert
"Amy Farrell" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Robert,
>
> I think your problem is not in the "while" loop, but in your use of
> write_row. (Which I guess makes this answer off-topic, if not the question
> its
On 5/9/05 9:39 PM, in article
[EMAIL PROTECTED], "Ian
Harisay" <[EMAIL PROTECTED]> wrote:
>
> This is really off topic.
>
Not so. I was more interested in how the fetchrow_arrayref works (or wasn't
working because of my ignorance). I probably should have posted just that
portion and left out
Robert,
I think your problem is not in the "while" loop, but in your use of
write_row. (Which I guess makes this answer off-topic, if not the
question itself.) Try write_col. The perldoc for
Spreadsheet::WriteExcel describes this behavior, with detailed
examples (granted, I'm having to make som
On 05/09/2005 12:45 PM, Robert said:
I am pulling data out of Oracle and putting it into an Excel spreadsheet.
Using this:
while ( $row = $sth->fetchrow_arrayref ) {
# this is a fast and simple way to deal with nulls:
foreach (@$row) { $_ = '' unless defined }
push (@results, @$row);
Th
This is really off topic.
-Original Message-
From: Robert [mailto:[EMAIL PROTECTED]
Sent: Mon 5/9/2005 1:45 PM
To: dbi-users@perl.org
Subject: Spreadsheet::WriteExcel question
My ignorance is showing. : )
I am pulling data out of Oracle and putting it into an Excel spreadsheet.
Using
