which DBI versin to use with perl 5.8.0

2003-09-04 Thread Farhan
hello. Which DBI module will work with my perl.. Version is.. perl, v5.8.0 built for MSWin32-x86-multi-thread. i'm on win2000. i'm asking this because when i try to install the DBI.ppd which i have the eror whcih appers is C:\rep>ppm install dbi.ppd "Error: no suitab

help required for DBI

2003-09-04 Thread Farhan
Can any one help me out from the error below.. i've been trying to use DBI module on win 2000 with Activeperl 5.6.4 and Perl 5.8 and Apache 2.0.. i dont know where i went wrong.. do i have to write any thing the system registry file.. plz help me out.. [Tue Sep 4 12:10:38 2003] [error] [client

Re: Theory/Algorithm question

2003-09-04 Thread Peter J. Holzer
On 2003-09-04 10:58:09 +0200, Kristian Nielsen wrote: > For fast insert, Oracle supports array execution where multiple sets of > bind variables are passed in a single execute (for example to insert > many rows in a single execute). Is this what you have in mind? I believe > a few DBD's support arr

No buffer space available - DBIProxy

2003-09-04 Thread Hamer, Corie J.
DBI::ProxyServer server failed to accept: No buffer space available I am getting this error message (above) every so often (sometimes 3 times a month, sometimes 3 times a day). This problem then causes my dbi::proxyserver to crash! Versions and Hardware: HPUX 11i Perl 5.6.1 DBI 1.21 RPC::PlServ

timeout

2003-09-04 Thread Murray Walker
I'm wondering if anyone's found a safe way to use $sth->cancel(); ? with/without SIG handlers. perl 5.6.1, Oracle 9i. http://search.cpan.org/author/TIMB/DBI-1.38/DBI.pm#Signal_Handling_and_Canceling_Operations BBCi at http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential

Re: Theory/Algorithm question (INSERT/UPDATE cursors)

2003-09-04 Thread Tim Bunce
On Wed, Sep 03, 2003 at 04:24:28PM -0700, Konigsberg, Jay wrote: > Hi all, > > The Perl DBI doesn't support INSERT, or UPDATE cursors, which is a pity, > because they can dramatically reduce the time it takes for many programs to run. Driver for databases which support named cursors should suppor

Re: INSERT/UPDATE cursor (was: Re: Theory/Algorithm question)

2003-09-04 Thread M. Addlework
--- Colin Wetherbee <[EMAIL PROTECTED]> wrote: > Hardy Merrill said: > > Kristian Nielsen [EMAIL PROTECTED] wrote: > >> Could you briefly explain what an INSERT/UPDATE cursor is? > > > > I also don't know what an INSERT/UPDATE cursor is. > > I know how a SELECT cursor works, but INSERT/UPDATE see

Re: INSERT/UPDATE cursor (was: Re: Theory/Algorithm question)

2003-09-04 Thread Mark Thornber
At 14:16 04/09/03, Colin Wetherbee wrote: Hardy Merrill said: > Kristian Nielsen [EMAIL PROTECTED] wrote: >> Could you briefly explain what an INSERT/UPDATE cursor is? > > I also don't know what an INSERT/UPDATE cursor is. I know how a SELECT cursor works, but INSERT/UPDATE seems voodoo to me. My c

ANNOUNCE: DBD::ADO 2.72

2003-09-04 Thread Steffen Goeldner
file: $CPAN/authors/id/S/SG/SGOELDNER/DBD-ADO-2.72.tar.gz size: 43463 bytes md5: d2afb2a7e0eeae9232b3b98eea8ceff6 Changes Version 2.72: 2003-09-03 Moved DBD::ADO::TypeInfo from DBD/ADO.pm to DBD/ADO/TypeInfo.pm. Fixed number of tests at t/15func.t. Fixed warning 'Use of uninitiali

INSERT/UPDATE cursor (was: Re: Theory/Algorithm question)

2003-09-04 Thread Colin Wetherbee
Hardy Merrill said: > Kristian Nielsen [EMAIL PROTECTED] wrote: >> Could you briefly explain what an INSERT/UPDATE cursor is? > > I also don't know what an INSERT/UPDATE cursor is. I know how a SELECT cursor works, but INSERT/UPDATE seems voodoo to me. My current PostgreSQL session doesn't seem t

Re: Theory/Algorithm question

2003-09-04 Thread Hardy Merrill
Kristian Nielsen [EMAIL PROTECTED] wrote: > "Konigsberg, Jay" <[EMAIL PROTECTED]> writes: > > > Hi all, > > > > The Perl DBI doesn't support INSERT, or UPDATE cursors, which is a pity, because > > they can dramatically reduce the time it takes for many programs to run. > > Could you briefly exp

RE: help required DBI

2003-09-04 Thread andy law (RI)
What database system are you using and have you installed the DBD module for that system (after installing DBI)? Later, Andy - Yada, yada, yada... The information contained in this e-mail (including any attachments) is confidential and is intended for the use of the addressee only

Re: help required DBI

2003-09-04 Thread Alex
make sure DBI is installed. use activeperl's ppm to do it for you On Tue, 12 Sep 2000, Farhan wrote: > > Can any one help me out from the error below.. i've been trying to use DBI module on > win 2000 with activeperl 5.6.4 and perl 5.8 and apache 2.0.. i dont know where i > went wrong.. do i h

Re: Bug: Doing a selectall_arrayref after disconnect

2003-09-04 Thread Tim Bunce
On Wed, Sep 03, 2003 at 05:36:43PM -0700, Daniel Lyons wrote: > DBD::Sybase It's a DBD::Sybase bug. Tim. > Perl 5.6.1 i686-linux > > >From the top of DBI.pm: > # $Id: DBI.pm,v 11.7 2002/02/07 03:00:53 timbo Exp $ > > >From the top of DBD/Sybase.pm: > # $Id: Sybase.pm,v 1.32 2001/12/13 01:05:2

Re: help required DBI

2003-09-04 Thread Colin Wetherbee
Freddy Söderlund said: >> The DBI module is looking for something, and it can't find _that_. >> You'll see the DBI module was located just fine, since the error occurs >> on its line 255. > > Good point! > There I learned something as well. Thanx! I actually thought the same thing you did, when I

Re: help required DBI

2003-09-04 Thread Freddy Söderlund
- Original Message - From: "Colin Wetherbee" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 11:14 AM Subject: Re: help required DBI > Freddy Söderlund said: > > First off, it seems that your script isn't printing the standard header > > that is needed. Th

Re: help required DBI

2003-09-04 Thread Colin Wetherbee
Freddy Söderlund said: > First off, it seems that your script isn't printing the standard header > that is needed. This is indicated by the "Premature end of script > headers:"-line. That's likely due to the script bailing out before it gets a chance to print the headers, rather than the absence o

Re: help required DBI

2003-09-04 Thread Freddy Söderlund
Hi there! First off, it seems that your script isn't printing the standard header that is needed. This is indicated by the "Premature end of script headers:"-line. I think that if you put the following line after your #!perl line it will fix that error: print "Content-type: text/html\n\n"; Seco

Re: Theory/Algorithm question

2003-09-04 Thread Kristian Nielsen
"Konigsberg, Jay" <[EMAIL PROTECTED]> writes: > Hi all, > > The Perl DBI doesn't support INSERT, or UPDATE cursors, which is a pity, because > they can dramatically reduce the time it takes for many programs to run. Could you briefly explain what an INSERT/UPDATE cursor is? Using DBD::Oracle,

help required DBI

2003-09-04 Thread Farhan
Can any one help me out from the error below.. i've been trying to use DBI module on win 2000 with activeperl 5.6.4 and perl 5.8 and apache 2.0.. i dont know where i went wrong.. do i have to write any thing the system registry file.. plz help me out.. [Tue Sep 4 12:10:38 2003] [error] [cli

Re: Odd behavior from DBD::CSV

2003-09-04 Thread Scott R. Godin
Unknown Sender wrote: > W li?cie z wto, 26-08-2003, godz. 18:33, Jeff Zucker pisze: >> Well, I thought so, and that's why AnyData works that way. But CSV >> worked with the "\015\012" default when I inherited it and there are too >> many scripts out there based on that behaviour for me to contemp

Re: fetch( ) without execute( ) Error...

2003-09-04 Thread James D. White
If the error is on the first fetchrow_hashref, there is not enough code to see what the problem is. If it is the second fetchrow_hashref, finish should be called after the while, if at all. If your while loop fetches all of the rows and fetches again to get the undef value which indicates no more d