On Thu, 2 Jan 2003 23:17:10 -0800 (PST), Michael A Chase wrote:
Comments interspersed.
Fortunately it is part of the trace() output.
Nevertheless, this is still a bug in DBI/Other. It's probably related
to the fact that with HandleError = sub ... DBI often outputs the
_previous_ SQL when an
On Fri, Jan 03, 2003 at 03:56:52AM +0200, Boris Penchev wrote:
Dear All,
I has this fromlem when I have a lot of MySQL request. Now i do not have free time
to explain this problem, but I give you smal
example:
my $sth = $dbh-prepare(qq~SELECT id, name FROM all~) || die $DBI::errstr\n;
On Fri, Jan 03, 2003 at 05:01:53AM +0200, Boris Penchev wrote:
Dear All,
1. Yes, I know that if you have prepare you can make a lot of execute of it, and
that i can make this query in start of my program
or in one module.
2. I think that is a good idea to declare $id and $name in while
On Fri, Jan 03, 2003 at 07:08:25PM +1100, Ron Savage wrote:
On Thu, 2 Jan 2003 23:17:10 -0800 (PST), Michael A Chase wrote:
Comments interspersed.
Fortunately it is part of the trace() output.
Nevertheless, this is still a bug in DBI/Other. It's probably related
to the fact that with
On Fri, Jan 03, 2003 at 01:35:15PM +1100, Steve Baldwin wrote:
I am getting the following error on disconnect ...
DBI::db=HASH(0x104dd094)-disconnect invalidates 1 active statement
handle (either destroy statement handles or call finish on them before
disconnecting) at yyy line xxx
Is
I have a script that loads large (40 Meg files) into a postgres
database. I would like to issue a vacuum and analyze, but I get the
message VACUUM cannot run inside a BEGIN/END block when I
try to send the message. Autoconfirm is off, an the vacuum
statement comes right after a commit.
I am
Folks
In this, admittedly unusual, situation the above occurs:
OS: Win2K
Perl: V 5.8.0
DBI: V 1.32
ODBC: 1.01
DSN: Points to a Microsoft Access database
Table name: Nathan Bailey (note the single space)
If I do:
select * from `Nathan Bailey`
it works. Yes, they are backticks.
If
I have a script that loads large (40 Meg files) into a postgres
database. I would like to issue a vacuum and analyze, but I get the
message VACUUM cannot run inside a BEGIN/END block when I
try to send the message. Autoconfirm is off, an the vacuum
statement comes right after a commit.
I am
On Fri, 2003-01-03 at 02:42, Tim Bunce wrote:
On Fri, Jan 03, 2003 at 05:01:53AM +0200, Boris Penchev wrote:
Dear All,
1. Yes, I know that if you have prepare you can make a lot of execute of it, and
that i can make this query in start of my program
or in one module.
2. I think that
On Fri, 3 Jan 2003 07:41:02 -0500, [EMAIL PROTECTED] wrote:
I have a script that loads large (40 Meg files) into a postgres database.
I would like to issue a vacuum and analyze, but I get the message VACUUM
cannot run inside a BEGIN/END block when I try to send the message.
Autoconfirm is off,
I'm a little confused by:
$db-{LongReadLen}=some_number;
This seems to me to effect insert and update but not read for text
fields. Is that right?
Quite the opposite. It should not affect regular text (char, varchar)
fields at all, but only long, blob, memo etc and when it does, it
If this is the wrong place for this post, please forgive the intrusion, and
perhaps suggest appropriate place?
Newbie trying to install Bundle::DBI and using the automated CPAN method.
The installation fails at the t/forkm.t test for Net-Daemon.
t/forkm.Starting server:
Hello
I wrote simple Apache::ASP page
---
HTML
BODY
%
use DBI;
use DBD::Informix;
my $dbh = DBI-connect(DBI:Informix:\@server, , ,{ PrintError =
0, AutoCommit = 1, });
my $rc=$dbh-disconnect;
%
/BODY
/HTML
---
This page (perl asp script) work fine, but only first time on apache
child
On Fri, Jan 03, 2003 at 07:57:01AM -0800, Michael Peppler wrote:
On Fri, 2003-01-03 at 02:42, Tim Bunce wrote:
On Fri, Jan 03, 2003 at 05:01:53AM +0200, Boris Penchev wrote:
Dear All,
1. Yes, I know that if you have prepare you can make a lot of execute of it, and
that i can make
On Fri, 2003-01-03 at 09:22, Tim Bunce wrote:
On Fri, Jan 03, 2003 at 07:57:01AM -0800, Michael Peppler wrote:
Adding a $sth-finish before the second execute() call fixes the
problem, of course.
The DBD::Sybase execute() method should effectively call finish() if
the statement handle
Hi,
I spent some considerable time attempting to get DBD::Oracle working and
wanted to share the solution in hopes of helping fellow travelers.
Here are the details of the environment:
HPUX 11.0
Oracle 8.1.7.2 64-bit
perl-5.8.0
DBI-1.30
DBD-Oracle-1.12
I assume this is the sort of thing you're talking about ...
- DESTROY for DBD::Oracle::st (DBI::st=HASH(0x105ec244)~INNER)
I'm not sure how this helps me. I can see a statement handle is being
destroyed, but how do I get more info on which one it is ?
Given that {CachedKids} already
On Fri, 3 Jan 2003 08:54:17 -0500, Jeff Urlwin wrote:
Folks
Ron,
Can you send me a small sample database directly? I'll look at it.
In
the mean time, try putting [] around the table name.
For the benefit of all:
1) I've sent Jeff the data
2) I've tried the []. That makes no difference
2) I'm
On Fri, 3 Jan 2003 06:26:41 -0800 (PST), Michael A Chase wrote:
Hi Michael
my($error);
$error = shift - text();
I tried this:
my $error = shift - text();
but of course it makes no difference in this context.
I then tried:
my $error;
$error = shift - text();
but of
See question below:
On Fri, 3 Jan 2003, Tim Bunce wrote:
On Fri, Jan 03, 2003 at 07:57:01AM -0800, Michael Peppler wrote:
On Fri, 2003-01-03 at 02:42, Tim Bunce wrote:
On Fri, Jan 03, 2003 at 05:01:53AM +0200, Boris Penchev wrote:
Dear All,
1. Yes, I know that if you have
On Sat, 4 Jan 2003 10:14:24 +1100 Ron Savage [EMAIL PROTECTED] wrote:
On Fri, 3 Jan 2003 06:26:41 -0800 (PST), Michael A Chase wrote:
my($error);
$error = shift - text();
I tried this:
my $error = shift - text();
but of course it makes no difference in this context.
I then
On Fri, 3 Jan 2003 18:34:36 -0500 (EST) Paul Boutros [EMAIL PROTECTED]
wrote:
On Fri, Jan 03, 2003 at 07:57:01AM -0800, Michael Peppler wrote:
The DBD::Sybase execute() method should effectively call finish() if
the statement handle is 'Active' when execute is called. That's one
of the
On Fri, Jan 03, 2003 at 06:34:36PM -0500, Paul Boutros wrote:
See question below:
On Fri, 3 Jan 2003, Tim Bunce wrote:
On Fri, Jan 03, 2003 at 07:57:01AM -0800, Michael Peppler wrote:
On Fri, 2003-01-03 at 02:42, Tim Bunce wrote:
On Fri, Jan 03, 2003 at 05:01:53AM +0200, Boris Penchev
On Sat, Jan 04, 2003 at 07:53:20AM +1100, Steve Baldwin wrote:
I assume this is the sort of thing you're talking about ...
- DESTROY for DBD::Oracle::st (DBI::st=HASH(0x105ec244)~INNER)
I'm not sure how this helps me. I can see a statement handle is being
destroyed, but how do I get
Hello list,
Sorry for reposting this, but I am really at a loss. Thank you for your
help.
I am pretty new in the Linux area and I am trying to install DBD:Oracle
on this platform. It tries to reach a 9i database (all tests were
directed to 9i on Linux and/or win2k).
I can connect directly in
How about simply displaying the {Statement} attribute in the message.
At least that would assist in tracking it down.
Do you think that would be easier to code ?
-Original Message-
From: Tim Bunce [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 4 January 2003 11:13 AM
To: Steve Baldwin
Cc:
Radu,
I notice that you are running the install as root. I normally don't set
root up to access Oracle. Since you are using root, do you have root's
environment setup to access the Oracle database and does SQL*Plus work from
the root id?
Mike
At 1/3/2003 03:13 PM, radu-ml wrote:
Hello
Maras Michal wrote:
I wrote simple Apache::ASP page
---
HTML
BODY
%
use DBI;
use DBD::Informix;
You don't need to 'use DBD::Informix'; it will be automagically loaded
when you run the connect.
my $dbh = DBI-connect(DBI:Informix:\@server, , ,{ PrintError =
0, AutoCommit = 1, });
When
28 matches
Mail list logo