Re: Spreadsheet::WriteExcel question

2005-05-10 Thread Amy Farrell
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 some

Re: Spreadsheet::WriteExcel question

2005-05-10 Thread Robert
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 the

DBI handling of attribute hash in DBI-connect

2005-05-10 Thread Mitch Kuppinger, MD
I am encountering this warning message when working with the sample database provided with MySQL 3rd ed., DuBois, Sams Publishing: Can't set DBI::db=HASH(0x81cfbdc)-{Autocommit}: unrecognised attribute or invalid value at /usr/lib/perl5/site_perl/5.8.3/i386-linux-thread-multi/DBI.pm line 648.

Re: DBI handling of attribute hash in DBI-connect

2005-05-10 Thread Tim
On Tue, May 10, 2005 at 12:02:47AM -0500, Mitch Kuppinger, MD wrote: I am encountering this warning message when working with the sample database provided with MySQL 3rd ed., DuBois, Sams Publishing: Can't set DBI::db=HASH(0x81cfbdc)-{Autocommit}: unrecognised attribute or invalid value at

RE: SEGV error

2005-05-10 Thread Jeff Urlwin
All, While executing CPAN's install DBD::ODBC command test #2 fails. Here is the output when run by hand: [snip] - do for DBD::ODBC::db (DBI::db=HASH(0x285918)~0x2714ec 'DROP TABLE PERL_DBD_TEST') Segmentation Fault(coredump) Not a pretty sight. This is attempting

Re: Executing Oracle stored procedures

2005-05-10 Thread Job Miller
The DBD::Oracle docs cover how to call stored procedures. However, if you have stored procedures that generate web pages via the mod_plsql web toolkit functions/procedures in the htp/htf packages, you should be using the mod_plsql gateway to execute them. Those functions/procedures are

Re: Spreadsheet::WriteExcel question

2005-05-10 Thread Robert
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 itself.) Try

RE: Executing Oracle stored procedures

2005-05-10 Thread Reidy, Ron
Metalink is your ally. See note 139548.1. No access to metalink? Google is your friend also - http://www.google.com/search?q=ora-6502sourceid=mozilla-searchstart=0start=0ie=utf-8oe=utf-8client=firefox-arls=org.mozilla:en-US:official - Ron Reidy Lead DBA Array BioPharma, Inc.

Fetching BIGINT Failed

2005-05-10 Thread Mohankumar
Hi Folks, I am using the Perl version 5.005_02, DBD::ASAny::VERSION = '1.12' and ASA 9.0.0. Fetching BIGINT failed when they contained more than 8 digits. I have a workaround by converting the BIGINT to VARCHAR using convert(). But this conversion is not possible for all kinds of customized

Re: Spreadsheet::WriteExcel question

2005-05-10 Thread Ian Harisay
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't

RE: SEGV error

2005-05-10 Thread Mark Vaughan
Jeff, Thanks for the response. I thought the same thing: Maybe it is failing because the table does not exist, so I created it using the same username and password. It still fails. I am trying to connect to an MS SQL Server running on a Win 2k server using the freetds driver and unixODBC

RE: SEGV error

2005-05-10 Thread Jeff Urlwin
Jeff, Thanks for the response. I thought the same thing: Maybe it is failing because the table does not exist, so I created it using the same username and password. It still fails. I am trying to connect to an MS SQL Server running on a Win 2k server using the freetds driver and

Re: Fetching BIGINT Failed

2005-05-10 Thread Michael A Chase
On 05/10/2005 07:10 AM, Mohankumar said: I am using the Perl version 5.005_02, DBD::ASAny::VERSION = '1.12' and ASA 9.0.0. Fetching BIGINT failed when they contained more than 8 digits. I have a workaround by converting the BIGINT to VARCHAR using convert(). But this conversion is not possible for