Re: Column names when using selectall_arrayref

2006-05-03 Thread Jonathan Leffler
On 5/3/06, Bill Moseley <[EMAIL PROTECTED]> wrote: How do I get the column names as a list to match the order of the rows returned when using select/fetchall_arrayref and using an ARRAY slice? I'm not having luck finding it in the docs. I don't know the column names ahead of time -- I'm passed

Column names when using selectall_arrayref

2006-05-03 Thread Bill Moseley
How do I get the column names as a list to match the order of the rows returned when using select/fetchall_arrayref and using an ARRAY slice? I'm not having luck finding it in the docs. I don't know the column names ahead of time -- I'm passed a query and want to return the data in the column or

Re: How to bind to a LARGE array

2006-05-03 Thread Ron Savage
On Wed, 3 May 2006 10:53:58 +0200, Bealach Na Bo wrote: Hi Bealach > I agree, a Perl snippet to generate the scalar @names place holders > would probably push the query over max query size, as well as > various other name space limits. Probably a bad idea. I found with Postgres V 7 I had to limi

Re: Installing DBD::Oracle on HP/UX

2006-05-03 Thread Peter J. Holzer
On 2006-05-02 15:02:46 -0400, Robert Hicks wrote: > Peter J. Holzer wrote: > >On 2006-05-01 14:07:02 -0400, Robert Hicks wrote: > >>It tried to connect with the scott/tiger thing on a lot of tests...and they > >>fail (of course). > >You can tell the testsuite to use a different user by setting the

Re: How to bind to a LARGE array

2006-05-03 Thread Alexander Foken
On 03.05.2006 10:53, Bealach Na Bo wrote: Thank you all for your comments. I think a temporary table is unavoidable if I want to control the way the query is done here (as opposed to letting the planner do its job). The @names array is the result of an earlier DBI query. So why don't you jus

DBD::Oracle and Visual C++ 2005 Express Edition.

2006-05-03 Thread John Scoles
Just a quick note to anyone out there who wants to compile DBD::Oracle on a windows box. It seems that Microsoft Visual C++ toolkit 2003 has been replaced by Visual C++ 2005 Express Edition. I have not yet had much time to play with this new platform but so far it does not seem to compile DBD::Or

Re: How to bind to a LARGE array

2006-05-03 Thread Bealach Na Bo
Thank you all for your comments. I think a temporary table is unavoidable if I want to control the way the query is done here (as opposed to letting the planner do its job). The @names array is the result of an earlier DBI query. I agree, a Perl snippet to generate the scalar @names place holder