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

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 dri

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 device

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

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: 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-6502&sourceid=mozilla-search&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls=org.mozilla:en-US:official - Ron Reidy Lead DBA Array BioPharma,

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

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 des

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

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 va

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

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 som