Re: Multiple selectrow_array calls with statement handle error

2008-04-10 Thread pgodfrin
On Apr 10, 1:15 pm, [EMAIL PROTECTED] (Douglas Wilson) wrote: > To Christian Merz: > I'm executing this 1000's of times in the actual code, that is why I've > prepared the query rather than passing in the sql string every time. > > For now I am just calling execute(), fetchrow_array(), and finish()

Re: Multiple selectrow_array calls with statement handle error

2008-04-10 Thread Tim Bunce
On Thu, Apr 10, 2008 at 11:15:30AM -0700, Douglas Wilson wrote: > $dbh->trace(9); > > > ( $total ) = $dbh->selectrow_array( $sth, undef, $id ); > > > ( $total ) = $dbh->selectrow_array( $sth, undef, $id ); > > > A DBI trace should shed more light on it. Thanks. I believe this was fixed in DBI

Re: Multiple selectrow_array calls with statement handle error

2008-04-10 Thread Douglas Wilson
To Christian Merz: I'm executing this 1000's of times in the actual code, that is why I've prepared the query rather than passing in the sql string every time. For now I am just calling execute(), fetchrow_array(), and finish() explicitly. Below find the trace output: On Thu, Apr 10, 2008 at 7:5

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-10 10:26:50 -0500, James H. McCullars wrote: > At 09:08 AM 4/10/2008, Peter J. Holzer wrote: > >Why shouldn't it work with a CGI script? I can think of reasons why it > >wouldn't work with mod_perl, but none for a CGI script. > > Setting the environment variable worked for me from the

Re: question for DBD-Oracle driver

2008-04-10 Thread James H. McCullars
At 09:08 AM 4/10/2008, Peter J. Holzer wrote: Why shouldn't it work with a CGI script? I can think of reasons why it wouldn't work with mod_perl, but none for a CGI script. Setting the environment variable worked for me from the command line but never from a CGI script. The best explanatio

Re: Multiple selectrow_array calls with statement handle error

2008-04-10 Thread Tim Bunce
On Wed, Apr 09, 2008 at 04:29:48PM -0700, Douglas Wilson wrote: > With DBI 1.602 and DBD::Sybase 1.08 I get: > Can't locate object method "DELETE" via package "DBI::st" > on the second selectrow_array call. > > If I replace $sth with $sql in the selectrow_array calls, then it > works correctly. >

Re: question for DBD-Oracle driver

2008-04-10 Thread Ulisses Reina Montenegro de Albuquerque
On Thu, 2008-04-10 at 16:08 +0200, Peter J. Holzer wrote: > On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: > > At 02:17 AM 4/10/2008, Peter J. Holzer wrote: > > >>I've just been through an install of DBD::Oracle on a Solaris 10 > > >>machine and this was my experience as well. My needs w

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-10 08:27:06 -0500, James H. McCullars wrote: > At 02:17 AM 4/10/2008, Peter J. Holzer wrote: > >>I've just been through an install of DBD::Oracle on a Solaris 10 > >>machine and this was my experience as well. My needs were > >>complicated by the fact that I was running it as a CGI scri

Re: DB2.xs error

2008-04-10 Thread Jonathan Leffler
On Thu, Apr 10, 2008 at 5:01 AM, Hildo Biersma < [EMAIL PROTECTED]> wrote: > Simon Cheng wrote: > > > I'm trying to install DBD::DB2 1.0 onto AIX 5.3. perl makefile.pl runs > > ok > > > > but when I run make, I get this error > > "DB2.xs", line 115.9: 1506-025 (S) Operand must be a modifiable lval

Re: question for DBD-Oracle driver

2008-04-10 Thread James H. McCullars
At 02:17 AM 4/10/2008, Peter J. Holzer wrote: >I've just been through an install of DBD::Oracle on a Solaris 10 machine and > this was my experience as well. My needs were complicated by the fact that I > was running it as a CGI script and thus did not have a way to easily set an > enviro

Re: Multiple selectrow_array calls with statement handle error

2008-04-10 Thread Christian Merz
Hi Douglas, my 'perldoc DBI' (VERSION=1.43) says: # @row_ary = $dbh->selectrow_array($statement, \%attr, @bind_values); # This utility method combines "prepare", "execute" and "fetchrow_array" # into a single call. According to this * it is correct to use your $sql * there is no need to prepar

Re: DB2.xs error

2008-04-10 Thread Hildo Biersma
Simon Cheng wrote: Hi, I'm trying to install DBD::DB2 1.0 onto AIX 5.3. perl makefile.pl runs ok but when I run make, I get this error "DB2.xs", line 115.9: 1506-025 (S) Operand must be a modifiable lvalue. "DB2.xs", line 175.13: 1506-025 (S) Operand must be a modifiable lvalue. make: 1254-00

Multiple selectrow_array calls with statement handle error

2008-04-10 Thread Douglas Wilson
With DBI 1.602 and DBD::Sybase 1.08 I get: Can't locate object method "DELETE" via package "DBI::st" on the second selectrow_array call. If I replace $sth with $sql in the selectrow_array calls, then it works correctly. I did find a similar problem here: http://www.nntp.perl.org/group/perl.dbi.use

Re: question for DBD-Oracle driver

2008-04-10 Thread pgodfrin
On Apr 9, 1:07 pm, [EMAIL PROTECTED] (James H. McCullars) wrote: > At 10:47 AM 4/9/2008, pgodfrin wrote: > > >This will obviate the need to use LD_LIBRARY_PATH, which has some > >controversy surrounding it's use. I also found a strangeness for the > >install of DBD. If I remember correctly, the ins

DB2.xs error

2008-04-10 Thread Simon Cheng
Hi, I'm trying to install DBD::DB2 1.0 onto AIX 5.3. perl makefile.pl runs ok but when I run make, I get this error "DB2.xs", line 115.9: 1506-025 (S) Operand must be a modifiable lvalue. "DB2.xs", line 175.13: 1506-025 (S) Operand must be a modifiable lvalue. make: 1254-004 The error code from

Re: question for DBD-Oracle driver

2008-04-10 Thread Peter J. Holzer
On 2008-04-09 13:07:55 -0500, James H. McCullars wrote: > At 10:47 AM 4/9/2008, pgodfrin wrote: > > >This will obviate the need to use LD_LIBRARY_PATH, which has some > >controversy surrounding it's use. I also found a strangeness for the > >install of DBD. If I remember correctly, the install doc