ANNOUNCE: DBI 1.20

2001-08-24 Thread Tim Bunce
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.20.tar.gz size: 191676 bytes md5: 71002061526134cb4e0417e47a6b5b66 Changes in DBI 1.20,24th August 2001 WARNING: This release contains two changes that may affect your code. : Any code using selectall_hashref(), which was added in March 2001,

CPAN Upload: T/TI/TIMB/DBI-1.20.tar.gz

2001-08-24 Thread PAUSE
The uploaded file DBI-1.20.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.20.tar.gz size: 191676 bytes md5: 71002061526134cb4e0417e47a6b5b66 No action is required on your part Request entered by: TIMB (Tim Bunce) Request entered on: Fri, 24 Aug 2001 23:31:41 GMT R

is DBD::Oracle 1.08 recommended for production environments?

2001-08-24 Thread Gavin Sherlock
Hi, I noted that 1.07 specifically said it was not recommended for production environments. I wondered if the same was true of 1.08, as it doesn't say anything one way or the other, Cheers, Gavin ___ Gavin Sherlock Dept. of Genetic

Scheduled for deletion

2001-08-24 Thread Perl Authors Upload Server
According to a request entered by Tim Bunce the following files and the symlinks pointing to them have been scheduled for deletion. They will expire after 72 hours and then be deleted by a cronjob. Until then you can undelete them via https://pause.perl.org/pause/authenquery?ACTION=delete_files or

DBD::ODBC connection issue to SQL Server

2001-08-24 Thread Tim Harsch
Hi all, I have MS SQL Server 2000 on Win2K as my server, running EasySoft's ODBC:ODBC bridge server software. I have Red Hat Linux 7.1 as my client, running EasySoft ODBC:ODBC Client sofware. With DBI and DBD::ODBC installed. I am able to make connections to the server but am a little perplexe

Re: is DBD::Oracle 1.08 recommended for production environments?

2001-08-24 Thread Tim Bunce
On Fri, Aug 24, 2001 at 01:49:36PM -0700, Gavin Sherlock wrote: > Hi, > I noted that 1.07 specifically said it was not recommended for > production environments. I wondered if the same was true of 1.08, as it > doesn't say anything one way or the other, I've not heard of any significant pr

RE: binding cursors

2001-08-24 Thread Jones Robert Contr 81 CS/SCK
THE NEW CODE: #!/usr/bin/perl -w use DBI; use DBD::Oracle qw(:ora_types); print "connecting to database... "; $dbh = DBI->connect('DBI:Oracle:blah', 'blah', 'blah') || die $dbh->errstr; $dbh->{RaiseError} = 1; print "done!\n"; print "preparing the statement... "; $sth = $dbh

RE: binding cursors

2001-08-24 Thread Scott T. Hildreth
I don't see why you need a cursor, the while (@row = $sth->fetchrow_array) will only fetch a row at a time. > $sth = $dbh->prepare(q{ > BEGIN OPEN :cursor FOR > SELECT c_client_name > FROM client; > END; > }); > my $st

binding cursors

2001-08-24 Thread Doug Johnson
I'm sorry to bring this up again - it has been covered before on the list, but surprisingly nobody has come up with a solution. If anyone has come up against this problem and has been able to solve it, or even if you were unable to solve it, I'd love to hear from you! Oh, and the solution: 'don'

Compiling DBI in Perl on SCO OSR5.0.5

2001-08-24 Thread Scott Taylor
Here is the error messages I get when trying to compile DBI on an SCO OSR5.0.5 compile of Perl5.005. Does anyone know what I'm missing or how I can get the DBI module into my Perl install? (Perl and cc info. at end of message) Thanks. Scott. Output of perl Makefile.PL: (information ab

RE: SQL Query Question

2001-08-24 Thread wsheldah
Uh, I believe that version will return no records if a customer with another carrier used more bandwidth than the highest bandwidth QWEST customer. I would restrict both main AND subquery to QWEST, to get the most bandwidth used by a QWEST customer. Mark Sheinbaum <[EMAIL PROTECTED]> on 08/2

DBI problems with Mod Perl

2001-08-24 Thread Faine, Mark
System : Solaris 8 ActivePerl 5.6.1 build 628 Apache 1.3.20 Mod Perl 1.26 Trying to start the server I have a startup script with the following: #! /bin/perl use strict; use lib "/usr/local/apache/perllib"; # make sure we are in a sane environment. $ENV{GATEWAY_INTERFACE} =~ /^CGI-Perl/ or

Re: Oracle Perl and DBI , dbd problem while inserting report in Japanese

2001-08-24 Thread Kawai,Takanori
Hi. #If you can read Japanese, I can send you in Japanese :-) #It is not easy for me to write mail in my poor English. - Original Message - From: "Maruti Chavan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, August 23, 2001 7:59 PM Subject: Oracle Perl and DBI , dbd problem w

problem using DBI and exec function

2001-08-24 Thread Steve Cameron
I have developed a Perl cgi script that takes a significant amount of time to complete. Users who start the script from a web interface can go to another page without waiting for the script to finish which can cause problems. I have tried to use the exec command to start a new process that cannot

RE: SQL Query Question

2001-08-24 Thread Mark Sheinbaum
select company,carrier from customers where this_month = (select max(this_month) from customers) and carrier = 'QWEST' -Original Message- From: Jeff Eckermann [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 23, 2001 11:28 AM To: Isaac; [EMAIL PROTECTED] Subject: Re: SQL Query Question

RE: Problem with DBD::Oracle with mod_perl

2001-08-24 Thread Kyle Oppenheim
We've seen this happen before. Unfortunately, I don't have a fix for you but I here's where we left off our chase... 1. ORA-03113: end-of-file on communication channel (for unknown reason, maybe a network blip?) 2. We have some code that will catch this error and call DBI->connect again. 3. Ap

Bug - undefined symbol PL_no_modify ---: from Oracle.so (DBD::Oracle)

2001-08-24 Thread Ulisses Gomes
Hi, I hope that is the right place to put my question. I'm using Perl2Exe (www.perl2exe.com.) to get executable for Win32 e Linux platform from perl source files. Our application 'ibizGer' uses DBI with DBD::Oracle. Our target is Win32 & Linux platform. It works fine when called by perl : >

Oracle Perl and DBI , dbd problem while inserting report in Japanese

2001-08-24 Thread Maruti Chavan
hi ..all I have problem ...to stored data in japanese ( Kanji ) data.. My setup is like this . I have NT with Japanese language and oracle 8.1.6 installed on same . i have one other ox where Linux - Redhat 7.1 English plus supporting japanese with oracle client and apapche webserver is running su