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
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
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
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
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,
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
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
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
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
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
is anyone else receiving two copies of emails sent by the listers???
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
--
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
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
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
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,
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
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 = '
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
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
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
please ignore.
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
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
- 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
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
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
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.
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
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
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
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...
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
33 matches
Mail list logo