RE: DBD::Oracle and m2o.pl

2004-12-29 Thread Reidy, Ron
Or he can use SQL*Loader to load it in. -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Michael A Chase tech [mailto:[EMAIL PROTECTED] Sent: Wed 12/29/2004 7:04 PM To: Maldonado, Daniel CW2 CTARNG Cc: dbi-users@perl.org Subject:Re: DBD::Oracle and

Re: DBD::Oracle and m2o.pl

2004-12-29 Thread Michael A Chase tech
On 12/29/2004 10:56 AM, Maldonado, Daniel CW2 CTARNG said: Hi there again, this may not be the best forum to ask this question but I don't think there is a DBD::Oracle list available. This is the right place. The DBI list is a good first stop for all DBI and DBD user issues. Does anyone have a s

Re: Can't install DBI

2004-12-29 Thread Michael A Chase tech
On 12/29/2004 08:05 AM, Bender Eliyahu-Yosef-BEB067 said: I installed ActivePerl- 5.8.6.811-MSWin32 opened MS-DOS window wrote ppm and then install DBI. The respond I got was : Error : No Valid repositories: Error : 500 Can't connect to ppm.Activestate.com:80 < Bad hostname 'ppm.ActiveState.com'> W

Re: Parallel::ForkManager && DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Ron Wingfield [RW], on Wednesday, December 29, 2004 at 10:29 (-0600) wrote the following: RW> I know my comments do not provide an immediate solution, but RW> this could be a very interesting thread.  Infact, I'm going to be RW> writing some IPC intensive code in the near future, and I want to RW>

FW: unable to install DBD::Oracle

2004-12-29 Thread Capacio, Paula J
Sorry if double posted: Got a delivery error on liooil's eaddr and correcting Jan 28th Conversation: From: liooil Response by: Paula >Hope this topic is not [EMAIL PROTECTED] >relevant. My Apologies if it's the case... No, the right list is the DBI-Users list http://lists.cpan.org/showlist.c

RE: unable to install DBD::Oracle

2004-12-29 Thread Capacio, Paula J
Jan 28th Conversation: From: liooil Response by: Paula >Hope this topic is not [EMAIL PROTECTED] >relevant. My Apologies if it's the case... No, the right list is the DBI-Users list http://lists.cpan.org/showlist.cgi?name=dbi-users >Well, i'm trying to port a perl script from solaris to Act

Off Topic: Tsunami

2004-12-29 Thread Ron Wingfield
I know that this is off-topic, but I'm fortunate to be able to work at home these days, and I keep the TV on for "white" noise. Still, the news that is filtering-in about this Indian Ocean tsunami is nothing short of apocalyptic. I know that this list has an international audience and some of

Re: Problem with "while/fetchrow_array"

2004-12-29 Thread Chris Denman (Protext)
With all due respect, why don't you learn how to program like the rest of us. I learned to program with research and trial and error. I used search engines, purchased books and borrowed code. It took me ages to get a script to run, let alone connect to a database (permissions!). I think I have

Re: Parallel::ForkManager && DBI memory leak ?

2004-12-29 Thread Cosimo Streppone
Follett, Robert wrote: You will get much better performance by connecting once, outside your foreach loop as well as disconnecting and finishing after the loop. Having tried this, I can assure you that connecting *inside* the loop is the only alternative here. In fact, for every loop iteration, Par

Re: Problem with "while/fetchrow_array"

2004-12-29 Thread Ron Wingfield
Thanks Hardy, I suspect that you are correct, sir! I'm going to go pickup a copy of "Programming the Perl DBI" book, today. I believe that's an O'Reilly publication, isn't it? (I can "Google" it.) By the way, I've just executed the following code. Notice that there is no "while" loop, but ra

DBD::Oracle and m2o.pl

2004-12-29 Thread Maldonado, Daniel CW2 CTARNG
Hi there again, this may not be the best forum to ask this question but I don't think there is a DBD::Oracle list available. Does anyone have a script that can convert a mysqldump file to a sqlplus script? Oreilly lists it at: http://www.oreillynet.com/oracle/os_dir/commandline.csp But I can't f

RE: Problem with "while/fetchrow_array"

2004-12-29 Thread Graeme St. Clair
The relevant line in an app I support says:- while (my @row = $sth->fetchrow_array) { blah } # Note @ not $, also no operands. I am no Perl expert, but I think you may have one of those differences arising from "context". Rgds, GStC. -Original Message- From: Ron Wingfield [mailto:[

Re: Problem with "while/fetchrow_array"

2004-12-29 Thread Hardy Merrill
Ron, someone else will correct me if I'm wrong, but long ago this bit me also. I believe I remember the answer being that "SHOW" is a mysql client command - that is not a valid SQL command. I'm not sure if mysql has a mysql-only sql command you can give to get the names of the databases - or may

Problem with "while/fetchrow_array"

2004-12-29 Thread Ron Wingfield
Hello everyone, I'm having difficulty solving this code problem. I can load a popup list of states from a "states" table, but I can't seem to get-it-right when I execute a SHOW, rather than a SELECT query. Actually, I want to create a popup list of all DATABASES through the CGI. From the com

Re: RE: Evaluated "require $database" not found.

2004-12-29 Thread amonotod
> From: "Ron Goral" <[EMAIL PROTECTED]> > Date: 2004/12/26 Sun PM 10:35:37 CST > > -Original Message- > > From: Jeff Zucker [mailto:[EMAIL PROTECTED] > > Sent: Sunday, December 26, 2004 10:30 PM > > Paul Boutros wrote: > > > use strict; > > > my $val = 'DBI'; > > > require $val; > > > > T

Re: Parallel::ForkManager && DBI memory leak ?

2004-12-29 Thread Ron Wingfield
I know my comments do not provide an immediate solution, but this could be a very interesting thread. Infact, I'm going to be writing some IPC intensive code in the near future, and I want to interface via Perl and web browsers. First, are you running on an MS/Windows or Unix server? Fork is a

Can't install DBI

2004-12-29 Thread Bender Eliyahu-Yosef-BEB067
Hi, I installed ActivePerl- 5.8.6.811-MSWin32 opened MS-DOS window wrote ppm and then install DBI. The respond I got was : Error : No Valid repositories: Error : 500 Can't connect to ppm.Activestate.com:80 < Bad hostname 'ppm.ActiveState.com'> What should I do ? Best Regards, Eli. Email: [

RE: Parallel::ForkManager && DBI memory leak ?

2004-12-29 Thread Follett, Robert
You will get much better performance by connecting once, outside your foreach loop as well as disconnecting and finishing after the loop. Also read up on prepare_cached using bind params. You will want to prepare outside your foreach as well. The only thing you need to do inside your loop is as

Re: Parallel::ForkManager && DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Moosmann, James [MJ], on Wednesday, December 29, 2004 at 07:07 (-0500) thoughtfully wrote the following: MJ> I am really disappointed with Perl's lack of support for any reliable. MJ> multithreaded behavior. I keep hoping it gets fixed. But I have waited for MJ> 2 years. ahm, I wrote some posts

Re: Parallel::ForkManager && DBI memory leak ?

2004-12-29 Thread Thilo Planz
Hello, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I looked around I come to Parallel::ForkManager module, easy to use. I do not know Parallel::ForkManager

Parallel::ForkManager && DBI memory leak ?

2004-12-29 Thread Ing. Branislav Gerzo
Hi pals, this is my first post to this mailing list. I have one problem, it is maybe for you small, but for me a big problem. If I want improve my scripts I _have_ to use parallel DB access. When I looked around I come to Parallel::ForkManager module, easy to use. When I wrote script, I saw it is