> file: $CPAN/authors/id/T/TI/TIMB/DBI-1.24.tar.gz
You're getting nearly as bad as I am :-)
Any idea when you are going to update the DBI book (I'm
going to push hard on my company to buy copies when it
comes out )?
Chicago just hit summer: we traded cold & rainy for heat
and thunderstorms.
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.24.tar.gz
size: 247067 bytes
md5: bd90aa392284bd127eada136769aee3a
=head2 Changes in DBI 1.24,4th June 2002
Fixed reference loop causing a handle/memory leak
that was introduced in DBI 1.16.
Fixed DBI::Format to work with 'filehandles' f
The uploaded file
DBI-1.24.tar.gz
has entered CPAN as
file: $CPAN/authors/id/T/TI/TIMB/DBI-1.24.tar.gz
size: 247067 bytes
md5: bd90aa392284bd127eada136769aee3a
No action is required on your part
Request entered by: TIMB (Tim Bunce)
Request entered on: Wed, 05 Jun 2002 03:31:56 GMT
R
On Tue, 4 Jun 2002, Bart Lateur wrote:
BL> I'm interested in creating SQL batch files, containing SQL statements.
BL> MySQL user may compare them to the output mysqldump produces. In order
BL> to properly generate INSERT statements with string values, I need to
BL> properly quote them. Now, I cou
I'm running this up against a csv file that's approximately 42K in size and
has 372 records in it (about 10 fields). And, it takes quite a bit of time
to perform each UPDATE sql statement. I've tried a few different ways of
performing the update, and this is my latest rendition:
Any ideas on ho
Stefan,
What settings do you need?
Jeff
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of
> Stefan Mueller
> Sent: Tuesday, June 04, 2002 12:43 PM
> To: DBI Mailingliste
> Subject: Subclassing DBD::ODBC
>
>
> Hello,
>
> I want to try to subclass DB
Jeff,
Attached (and included) is a large patch that implements the
primary_key and column_info meta data methods now supported in
DBI. The column_info does not present all the information
possible (someone knowing more about the Pg system tables could
conti
Oops. Here is my configuration information:
#
# Perl version
This is perl, v5.6.1 built for MSWin32-x86-multi-thread
(with 1 registered patch, see perl -V for more detail)
Copyright 1987-2001, Larry Wall
Binary build 631 provided by ActiveState Tool Corp.
http://www.ActiveState.com
Built 17:16
Level B error.
After making the following hacks, I was able to get a build - but nearly all
the tests failed (Level C error). So my hacks may not have been 'good
enough'.
Configuration.pm
(After Line 58) added
# Need to put quotations around entire string if spaces in string
if( $esql
It depends what Oracle's default date format is. Eg it could be MMDD,
but you are trying to insert a string with date and time. Work out what
Oracle date format your character string is in, then either use something
like:
$dbh->do("ALTER SESSION SET NLS_DATE_FORMAT = 'MMDDHH24MISS'");
t
hey all--
I just started with a research lab that has been storing collected
data in several different microsoft access databases. There are some
duplicate records, different formats for the tables-- it's a mess.
I have been charged with synching the data and getting it into one
On Tue, Jun 04, 2002 at 06:43:20PM +0200, Stefan Mueller wrote:
> Hello,
>
> I want to try to subclass DBD::ODBC.
>
> Via ODBC I can connect a lot of databases. But for some database
> connections I need specific parameters for $dbh. So, I want to hide
> these parameters in a new pseudo driver.
Yes. (I think I'd already said that in previous emails.)
Tim.
On Tue, Jun 04, 2002 at 11:26:21AM -0400, [EMAIL PROTECTED] wrote:
> Another DBI? Wow! Quickly, will the new version address the
> following issues:
>
> #
> # From:Jeff Zucker
> # Subject: Re: Private fu
When execute() is called with no params then the driver uses the
values previous bound by calls to bind_param(). The driver (or the
underlying database API) ought to check that bind_param() has been
called at least once for each parameter.
Tim.
On Tue, Jun 04, 2002 at 12:21:28PM -0400, Jeff Boes
The Oracle client from technet.oracle.com
Ilya
-Original Message-
From: Roger Patrick
To: [EMAIL PROTECTED]
Sent: 6/4/02 12:06 PM
Subject: Installing Perl DBD
I have a Unix application server that I would like to install Oracle
DBD, that doesn't have Oracle installed.
What Oracle compo
I have a Unix application server that I would like to install Oracle DBD, that doesn't
have Oracle installed.
What Oracle components do I have to install on the application server in order to
successfully install the Oracle DBD driver.
I'm running Oracle 8.1.7
Thanks,
Roger Patrick.
Oh, sorry.
http://xmlproj.dyndns.org/dbi/faq.html
-Original Message-
From: Dave Bates
To: Sterin, Ilya; [EMAIL PROTECTED]
Sent: 6/4/02 10:00 AM
Subject: RE: DBI Installing Problems
404 not found.. :)
>From: "Sterin, Ilya" <[EMAIL PROTECTED]>
>To: 'Dave Bates' <[EMAIL PROTECTED]>, [EMA
Wolfgang Weisselberg wrote:
>
> At 2002-05-28 10:18:51 (+0200), Bart Lateur wrote:
>
First, thanks Wolfgang and Bart! I really appreciate the fact that
you've taken the trouble to think about this and make suggestions.
>>On Wed, 22 May 2002 19:27:02 +0200, Wolfgang Weisselberg wrote:
>>
>
Hello,
I want to try to subclass DBD::ODBC.
Via ODBC I can connect a lot of databases. But for some database
connections I need specific parameters for $dbh. So, I want to hide
these parameters in a new pseudo driver.
Is it possible to subclass a DBD Driver without a lot of trouble? How
can I
I had no response to this earlier posting. Has anyone else experienced
this problem? Am I doing something stupid here?
On Thu, 2002-05-30 at 12:05, Jeff Boes wrote:
> I'm using DBI V1.21, DBD::Pg V1.12. Given this setup:
>
> #!/usr/bin/perl -w
> use strict;
> use DBI;
> my $dbh = DBI->connec
According to "Programming the Perl DBI" the connect string is VERY
dependant.
There are a few examples on page 84, Chapter 4.
But should be documented in the DBD that you are downloading.. in thier POD
documentation.
>From: Bart Lateur <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: The
404 not found.. :)
>From: "Sterin, Ilya" <[EMAIL PROTECTED]>
>To: 'Dave Bates' <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
>Subject: RE: DBI Installing Problems
>Date: Mon, 3 Jun 2002 23:22:07 -0400
>
>Well, there are other ways of connecting to it as well. See the FAQ
>
>http://xmlproj.dyndns.org/d
At 2002-05-28 10:18:51 (+0200), Bart Lateur wrote:
> On Wed, 22 May 2002 19:27:02 +0200, Wolfgang Weisselberg wrote:
> >BTW, I think zpack could be done better by copying the original
> >to .bak, generate a new DB .new (as done in zpack) and then
> >atomically rename .new to be the database. But
Another DBI? Wow! Quickly, will the new version address the
following issues:
#
# From:Jeff Zucker
# Subject: Re: Private functions in PurePerl ?
#
To make it available to other handles, comment out lines 175, and 176 in
DBI::PurePerl and add the line as sho
It's been fun to do some real creative development work on the DBI again.
Here's the docs for the fruit of my labours.
Comments welcome, preferably soon. I plan to make a new DBI release
including this work inside the next 8 hours or so.
Tim.
p.s. That release will also fix a reference-loop db
I'm interested in creating SQL batch files, containing SQL statements.
MySQL user may compare them to the output mysqldump produces. In order
to properly generate INSERT statements with string values, I need to
properly quote them. Now, I could use the quote() method from a DBI
connection handle.
I'm curious: why is the connect string in the format that it is? For
example, the most simple for is like:
dbi:mysql:mydb
What is the "dbi" for? "mysql" is the driver -- actually, the driver is
DBD::mysql. This has caused me more mistypes than I care to remember.
"mydb" is the database n
Hello,
It's very helpful for me if you could spend some time on reading it.
I have a problem about how to insert a column value which type is "DATETIME"
? I tried to use $sth->bind_param(1, $value1, SQL_CHAR);
But it doesn't work. And I got an error message like below :
DBD::Oracle::st execute f
28 matches
Mail list logo
