Re: Using perl 5.8.0?

2003-02-26 Thread Jarkko Hietaniemi
On Tue, Feb 25, 2003 at 05:05:59PM -0500, Lincoln Stein wrote: My test case is part of a big script that requires BioPerl. What I'll do is to pull it out into a self-contained script. Frankly I don't think that this has anything to do with DBI, but rather something fundamental that

Re: Using perl 5.8.0?

2003-02-26 Thread Tim Bunce
On Tue, Feb 25, 2003 at 05:30:31PM -0500, Thomas Good wrote: On Tue, 25 Feb 2003, Tim Bunce wrote: While I was using 5.8 large data transfers via DBI failed consistently. I have compared notes with others (including Lincoln Stein) and this problem is easily reproduced. In fact, I

Re: Using perl 5.8.0?

2003-02-26 Thread Peter J. Holzer
On 2003-02-25 21:34:52 -0800, Jonathan Leffler wrote: Generally speaking, I've been impressed with 5.8.0 on both Solaris 7 (UltraSparc) and also on MacOS X (10.2.3 at the moment). On MacOS X, there's a peculiarity in the way CPAN and CPANPLUS manage to put the first character of output on

Re: Encryption module

2003-02-26 Thread Nilanjan Das
Hi All, Thanks a lot for the responses. I used Crypt::CBC using Blowfish. It works as expected. I have one more query. Is there any way to store the key that we use to encrypt so that only the program that will decrypt it will get access to it? I can not store it in any database as I want to

Re: DBI error handling

2003-02-26 Thread Michael Houghton
Howdy! On Tue, Feb 25, 2003 at 09:46:07PM +, Tim Bunce wrote: On Tue, Feb 25, 2003 at 03:14:24PM -0500, Michael Houghton wrote: Howdy! I'm trying to write a WARN handler for an Informix application. I want to be able to get to stuff in the SQLCA, which, if I read things correctly,

DBD::CSV--Execution ERROR: Couldn't find column names!.

2003-02-26 Thread Snethen, Jeff
I've worked with the DBI some, but I'm now starting to experiment with DBD::CSV. I'm trying to read a table without column headers, letting CSV create the column names for me. If I understand the documentation correctly, an empty array reference should cause the driver to name the columns for

RE: Connecting perl to MS SQL on Tru64 Unix use freetds

2003-02-26 Thread Gordon Ross
Hi, I found similar issues when I upgraded from DBD::Sybase 0.94 to 0.95 working with FreeTDS. I ended up backing back down to DBD::Sybase 0.94 which works fine from both mod_perl and your standard CGI w/DBI app (or just your plain old administrative apps that

RE: :Oracle

2003-02-26 Thread Jeff Urlwin
Janet Hi, I'm trying to build/install DBD::Oracle. Have successfully installed Perl5.00503 - seems to be working ok. Have also installed 3 of the 4 Perl modules successfully. Having problems building DBD::Oracle from DBD-Oracle-1.02. When I try and build it can't find the Oracle OCI

MySQL DBI problem

2003-02-26 Thread gregg
I am trying to read email off a mail server using perl, parse it, and then store the fields in a MySQL database. I managed to write the first two parts in a couple of days, but now I've spent two weeks trying to get the fields into a the Messages database. I have got several fields to go in

RE: Using perl 5.8.0?

2003-02-26 Thread Neibarger Scott H
I'm afraid I can't offer any feedback that would be useful, other than the fact that Lincoln is most likely correct that this problem is manifested due to changes in PerlIO. I have several daemons running on Tivoli TMR servers, many of which use DBI and DBD::Oracle; one of which is experiencing

multiple posts

2003-02-26 Thread Markham, Richard
is anyone else receiving two copies of emails sent by the listers???

RE: multiple posts

2003-02-26 Thread shildreth
Nope.. On 26-Feb-2003 Markham, Richard wrote: is anyone else receiving two copies of emails sent by the listers??? -- E-Mail: [EMAIL PROTECTED] Date: 26-Feb-2003 Time: 11:24:01 --

Re: Using perl 5.8.0?

2003-02-26 Thread Tim Bunce
Ah, mentioning PerlIO and DBD::Oracle points the finger at the fact that DBD::Oracle hasn't been updated to use PerlIO for warnings/trace (at least not in the release on CPAN). That may be a factor. If DBD::Oracle needs to 'say' anything (which is very rare in normal operation) it'll be passing a

Re: MySQL DBI problem

2003-02-26 Thread Paul DuBois
I am trying to read email off a mail server using perl, parse it, and then store the fields in a MySQL database. I managed to write the first two parts in a couple of days, but now I've spent two weeks trying to get the fields into a the Messages database. I have got several fields to go in

Re: Encryption module

2003-02-26 Thread William R. Mussatto
Hi All, Thanks a lot for the responses. I used Crypt::CBC using Blowfish. It works as expected. I have one more query. Is there any way to store the key that we use to encrypt so that only the program that will decrypt it will get access to it? I can not store it in any database as I want

Re: MySQL DBI problem

2003-02-26 Thread gregg
No. I'm not using placeholders. I'm stuffing all my INSERT variables into a DO statement. The one example I found on place holders was a any DBI example for SELECT not INSERT. I changed the syntax and I didn't get an error but it wasn't inserted either. Thanks. On Wednesday, February 26,

Re: Using perl 5.8.0?

2003-02-26 Thread Susan Cassidy
I am using perl 5.8.0 and DBD-Oracle-1.12 with DBI-1.32, on Solaris 5.8. I have trouble inserting data into CLOBs if the data is over 32K, and the DBD does not understand Oracle type XMLDATA at all. I posted a question about this earlier, but no one appeared to know anything. Doesn't seem to

Re: MySQL DBI problem

2003-02-26 Thread Paul Boutros
It would definitely help if you post source-code. This might not be what you're looking for, but the general syntax for INSERTs might be something like: use DBI; use strict; my $user = 'username'; my $pass = 'password'; my $dbh = DBI-connect('dbi:MySQL:db_name', $user, $pass); my $sql = '

Re: MySQL DBI problem

2003-02-26 Thread Thomas Good
On Wed, 26 Feb 2003, Paul DuBois wrote: I have a few books on Perl that have DBI examples but they are not made for MySQL and the examples are very Mickey Mouse compared to what I'm trying to do. Any suggestions or directions to potential resources will be greatly appreciated. The webdb

RE: Using perl 5.8.0?

2003-02-26 Thread shildreth
I would like to take this moment to thank Lincoln Stein for his wonderful book Network Programming with Perl; it's been a wonderful resource for me ..has been a great resource for me as well. on this current project. If you've

DBD::Informix returning 0.0 as 0.00000E+00 ?

2003-02-26 Thread jeffery sumler
Hi-- I'm currently working on a project that involves replacing a number of scripts that are wrappers around Informix's dbaccess with DBI/DBD::Informix. An odd issue has cropped up: where dbaccess returns (or formats) what are I assume floating point types equal to zero as 0.0, DBI returns

test

2003-02-26 Thread Van Scoyoc, James
please ignore.

Running SQL scripts within perl using DBD::Oracle

2003-02-26 Thread Fernando Luna
There is the need at my organization to process DDL statements contained in a group of SQL files. I have been able to greatly simplify a number of tasks using perl and I was hoping to likewise be able to use perl and the DBD::Oracle modules to get this accomplished. I would like to know what

Re: [MP2] Apache::Reload date bug

2003-02-26 Thread Ron Savage
On Wed, 26 Feb 2003 19:41:02 +1100, Ron Savage wrote: On Wed, 26 Feb 2003 09:23:39 +1100, Stas Bekman wrote: Hi Stas Have you tried the current mod_perl cvs? No. Being usually a Windows (shudder) user, I wait for Randy to issue a build. Today I spent 4 hours failing to install Red Hat 6, Red

(Fwd) DBI - the book

2003-02-26 Thread Tim Bunce
- Forwarded message from Fernando Luna [EMAIL PROTECTED] - Delivered-To: [EMAIL PROTECTED] Subject: DBI - the book Date: Wed, 26 Feb 2003 13:56:21 -0800 From: Fernando Luna [EMAIL PROTECTED] To: [EMAIL PROTECTED] There is the need at my organization to process DDL statements contained

Re: Bug: DBI issues wrong (ie previous) SQL upon error

2003-02-26 Thread Tim Bunce
I believe this is due to DBD::mysql implementing its own do() method that does not creat a statement handle. I've worked around it by marking do (and prepare) as methods that should trigger the $h-{Statement} to be cleared on entry. That way if they don't set it before an error occurs then at

Re: Connecting perl to MS SQL on Tru64 Unix use freetds

2003-02-26 Thread Gordon Ross
Hi, I rebuilt freetds 0.60 as a 32 bit module (cc -taso) and tests using apache/perl/dbd-sybase/freetds so far have been successful (!!). I am very relieved. Since this caused memory to be re-organized, there still exists the possibility of memory trashing, but

Re: DBD::Informix returning 0.0 as 0.00000E+00 ?

2003-02-26 Thread Jonathan Leffler
jeffery sumler wrote: I'm currently working on a project that involves replacing a number of scripts that are wrappers around Informix's dbaccess with DBI/DBD::Informix. Consider getting SQLCMD from the IIUG software archive (http://www.iiug.org/software). It is designed to replace DB-Access.

Re: CPAN Upload: T/TI/TIMB/DBI-1.33.tar.gz - patch needed to DBD.pm

2003-02-26 Thread Jonathan Leffler
PAUSE wrote: The uploaded file DBI-1.33.tar.gz has entered CPAN [...] I see you repackaged both lib/DBI/DBD/GetInfo.pm and lib/DBI/DBD/TypeInfo.pm into lib/DBI/DBD/Metadata.pm. I think that's a good idea. You made the write_xxx_pm names uniform too, which is also a good idea, especially in

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

2003-02-26 Thread PAUSE
The uploaded file DBI-1.32_90.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.32_90.tar.gz size: 292645 bytes md5: 096c528e66026d3cf0cac6b6bf9dc87c No action is required on your part Request entered by: TIMB (Tim Bunce) Request entered on: Wed, 26 Feb 2003 18:00:25

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

2003-02-26 Thread PAUSE
The uploaded file DBI-1.33.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.33.tar.gz size: 299066 bytes md5: c6a737c990bc59f95c34657ec72ac68a No action is required on your part Request entered by: TIMB (Tim Bunce) Request entered on: Thu, 27 Feb 2003 00:24:06 GMT

Re: CPAN Upload: T/TI/TIMB/DBI-1.33.tar.gz -- test problem on MacOS X and Perl 5.8.0

2003-02-26 Thread Jonathan Leffler
PAUSE wrote: The uploaded file DBI-1.33.tar.gz has entered CPAN as file: $CPAN/authors/id/T/TI/TIMB/DBI-1.33.tar.gz Dear Tim, I downloaded DBI 1.33 from pause.cpan.org and tried to test it on my MacOS X box - and it mostly worked except for a problem with DBI::Shell...

FAIL DBI-1.33 i386-linux 2.4.16-6mdksmp

2003-02-26 Thread Automated Perl Test Account
This distribution has been tested as part of the cpan-testers effort to test as many new uploads to CPAN as possible. See http://testers.cpan.org/ Please cc any replies to [EMAIL PROTECTED] to keep other test volunteers informed and to prevent any duplicate effort. -- This is an error