Re: Compiling dbd-oracle on hpux64

2005-11-18 Thread John Scoles
I am collecting and writing a new version of the Makefile.pl for Oracle 10 XE I was just wondering if I could get a copy of your version of your makefile and any instaltion notes you might have. I am working with Tim Bunce on this project. Cheers John Scoles

Documentation / Error checking

2005-11-18 Thread Nitzan Shaked
(A bit long) (Bottom line: is it, or is it not, enough to always check DBI::err) Hello The documentation for how to check the success of various DBI calls, and in particular do(), selectrow_foo() and selectall_foo() is unclear and not precise, at least for me. Actually I am not sure, after

DBD::Oracle on HPUX (was: help me ,please!)

2005-11-18 Thread Tim Bunce
- Forwarded message from liu liu [EMAIL PROTECTED] - X-Pobox-Antispam: dnsbl/blackholes.five-ten-sg.com returned deny: for 65.54.168.32(bay113-f22.bay113.hotmail.com) X-Originating-IP: [211.94.130.232] X-Originating-Email: [EMAIL PROTECTED] From: liu liu [EMAIL PROTECTED] To: [EMAIL

Re: Documentation / Error checking

2005-11-18 Thread Tim Bunce
On Fri, Nov 18, 2005 at 02:15:50PM +0200, Nitzan Shaked wrote: (A bit long) (Bottom line: is it, or is it not, enough to always check DBI::err) Hello The documentation for how to check the success of various DBI calls, and in particular do(), selectrow_foo() and selectall_foo() is unclear

RE: Documentation / Error checking

2005-11-18 Thread Nitzan Shaked
Thanks Tim. I'll clarify the docs. Basically all methods calls reset err except for just a few special cases such as err and errstr, obviously, and FETCH eg $foo = $h-{SomeAttribute}). From the first part of your answer I understand that's it's always okay to test for defined DBI::err (if I

Re: anyway to determine # rows before fetch loop ends and without seperate count(*)

2005-11-18 Thread listmail
Well I'm not seeing why a number of arrays that each point to arrays could not be consider a matrix of arrays when considering one definition of the word matrix Something resembling such an array, as in the regular formation of elements into columns and rows. I dunno, i'm not trying to argue

RE: anyway to determine # rows before fetch loop ends and without seperate count(*)

2005-11-18 Thread Ronald J Kimball
listmail [mailto:[EMAIL PROTECTED] wrote: Well I'm not seeing why a number of arrays that each point to arrays could not be consider a matrix of arrays when considering one definition of the word matrix Something resembling such an array, as in the regular formation of elements into

RE: anyway to determine # rows before fetch loop ends and without seperate count(*)

2005-11-18 Thread Rutherdale, Will
Read standard books such as _Programming Perl_ by Wall etc. for information on array references. Generally references are the most efficient way to pass arrays around or return them from a function. Returning an array instead of a reference to an array means the whole array has to be copied.

Re: anyway to determine # rows before fetch loop ends and without seperate count(*)

2005-11-18 Thread JupiterHost.Net
listmail wrote: Well I'm not seeing why a number of arrays that each point to arrays could not be consider a matrix of arrays when considering one definition of the word matrix Something resembling such an array, as in the regular formation of elements into columns and rows. I dunno, i'm

Re: anyway to determine # rows before fetch loop ends and without seperate count(*)

2005-11-18 Thread listmail
which ultimately makes the 50 or 60 line script you sent originally about 10 lines or less. (IE by using the array of array setup instead of some convoluted matrix that is structured god know how. That means in six months when you (or heaven forbid me) have to maintain your code

Re: Documentation / Error checking

2005-11-18 Thread Tim Bunce
On Fri, Nov 18, 2005 at 03:49:21PM +0200, Nitzan Shaked wrote: Thanks Tim. I'll clarify the docs. Basically all methods calls reset err except for just a few special cases such as err and errstr, obviously, and FETCH eg $foo = $h-{SomeAttribute}). From the first part of your answer I

Re: anyway to determine # rows before fetch loop ends and without seperate count(*)

2005-11-18 Thread Tim Bunce
Let's close this thread now. Thanks. Tim.

changes to support Oracle 10 type BINARY_FLOAT

2005-11-18 Thread Dennis Box
I was able to get DBD-Oracle-1.16 to read and write the new Oracle 10 types BINARY_FLOAT and BINARY_DOUBLE with just a few small changes. I also found a problem with Makefile.PL where it couldn't seem to recognize the client_version output from sqlplus for Oracle 10.2, it does now and still