Nothing wrong with the build. You've still got old perl libraries sitting
around including an old DBI.
I have said a couple of times already to include the output of perl -V in
your posts. That's perl with a big "-V". This includes information about
your build of perl that will probably confirm
The URL
ftp://ftp.dev.ecos.de/pub/perl/dbi/DBIx-Recordset-0.24.tar.gz
has entered CPAN as
file: $CPAN/authors/id/G/GR/GRICHTER/DBIx-Recordset-0.24.tar.gz
size: 92611 bytes
md5: 76835b342ac63d731a4eb9529613ee99
DBIx::Recordset is a perl module for abstraction and simplification of
da
On Sun, 8 Jul 2001, M.W. Koskamp wrote:
[snippage]
> You could also issue a:
> select count(keyfield)
> from sometable
> where someclause
>
> I did some benchmarks and found that is was faster then a where exists.
Hi. The original poster, here. I took four of the suggestions
that folks
Hi,
I'm running into a problem with the 'default' binding
of char columns with Oracle.
I get no results with:
# example #1
$parm = '01634';
$sth = $dbh->prepare('select char_column from table where table.char_column = ?');
$sth->execute($parm);
but this works fine:
# example
True. That does sound like the best solution. But, how will the major
RDBMS' handle this? If they cache the first N, maybe up to available cache
memory, then the cache needs to be refilled again by other processes that
need it. Not wanting to get in to DB optimization techniques, but don't
wan
On Mon, Jul 09, 2001 at 10:32:56AM -0700, Tim Harsch wrote:
>
> > Regarding Oracle, it stops after the first row that matches. I
> > tested this
> > on a table with 50 million rows, with a where clause that would select 20
> > million rows. The query returned in seconds. Here are the statistic
> -Original Message-
> From: Tim Harsch [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 10:33 AM
> To: Ronald J Kimball
> Cc: M.W. Koskamp; Thomas A. Lowery; [EMAIL PROTECTED]
> Subject: RE: Checking for the existence of a certain row.
>
>
>
>
> > -Original Message-
I haven't seen anything on this thread related to DBI (but have
seen at least some misinformation about Oracle). Does
anyone know of some kind of 'any-db' sql list where this
would be appropriate? If so, I'd be happy to add my 2 cents
there.
-Chris
> -Original Message-
> From: Michael P
Yeah I thought about that too right at the end of my response. It sounds
like he didn't have an index.
> -Original Message-
> From: Michael Peppler [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 10:48 AM
> To: Tim Harsch
> Cc: Ronald J Kimball; M.W. Koskamp; Thomas A. Lowery; [
Tim Harsch writes:
>
>
> Don't think so, the database would clearly have to visit every row in order
> to know there are none that match.
Wrong... at least for Sybase.
In a table with 4 million rows, doing a check on an indexed column:
select 1 from eC_user where exists (select * f
> -Original Message-
> From: Ronald J Kimball [mailto:[EMAIL PROTECTED]]
> Sent: Monday, July 09, 2001 6:33 AM
> To: Tim Harsch
> Cc: M.W. Koskamp; Thomas A. Lowery; [EMAIL PROTECTED]
> Subject: Re: Checking for the existence of a certain row.
>
>
> On Sun, Jul 08, 2001 at 12:52:45PM -07
Thanks for the replies! (Especially you, Dean :)
I finally got it to work. YAY!
Here's the code that worked if anyone is interested:
#! /usr/bin/perl -wT
use CGI;
use DBI;
use CGI::Carp qw(fatalsToBrowser);
$dbh = DBI->connect("DBI:mysql:mydatabase", "username", "password") || die
$DBI::err
- Original Message -
From: "M.W. Koskamp" <[EMAIL PROTECTED]>
To: "anshuman das" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 09:36
Subject: Re: Further progress::Can't locate objrect method "connect" via
package "DBI"
> - Original Mess
- Original Message -
From: anshuman das <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, July 09, 2001 8:04 AM
Subject: Further progress::Can't locate objrect method "connect" via package
"DBI"
> As you told I am sending the log files of installation pr
On Sun, Jul 08, 2001 at 12:52:45PM -0700, Tim Harsch wrote:
> but, does this (Sybase specific) query:
> select 1 where exists
> ( select * from some_table where some_column = 'some_value')
>
> and/or this Oracle specific query:
> select 1 from dual where exists
> ( select * from some_table where
Dear Members,
I am the author/maintainer of DDL::Oracle. A bug has recently been
logged which I can duplicate, but I believe the bug is in DBD::Oracle (or
maybe Oracle?).
The user reporting the bug is using:
- RedHat 7.1- DBI-1.18
- DBD-Oracle-1.07
- DDL-Oracle-1.10
- Oracle Client 8.0.5.0.0
Hallo there,
I've identified a problem with the DBD-Oracle 1.07 (the same problem occurs
with DBD-Oracle 1.06) and
the Oracle 8.1.6.0.0 client libraries connected to a 8.1.7.0.0 database.
Under Windows 2000, the process crashes with a general exception error
(0xC005, access violation)
while p
On 2001-07-07 19:51:24 -0700, Michael A. Chase wrote:
> - Original Message -
> From: "Steve Howard" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Saturday, July 07, 2001 19:47
> Subject: RE: Checking for the existence of a certain row.
>
>
> > (I'm installing
[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
> Hello Everyone,
>
> The code I'm including makes the line graph I want, except that no points are
> plotted. It comes out as an empty graph with only the 0 for elevation on the
> Y-axis label and the first date, 2001-01-01, on the X-axis label. I
On 2001-07-07 18:16:26 -0500, Steven Lembark wrote:
> - Steve Howard <[EMAIL PROTECTED]> on 07/07/01 17:54:18 -0500:
>
> > do a
> > SELECT COUNT(*) FROM WHERE ...
> >
> > A count is almost always faster than actually returning that row, and
> > requires even less network bandwidth to return the
> -Original Message-
> From: Michael A. Chase [mailto:[EMAIL PROTECTED]]
> Sent: 08 July 2001 03:51
> To: Steve Howard; [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: Re: Checking for the existence of a certain row.
>
>
> - Original Message -
> From: "Steve Howard" <[EMAIL PROTE
Hi,
I have a working environment of DBI, we want to upgrade to
a newer version of Informix Client SDK, do I need to rebuild
the DBD::Informix with the newer version of Client SDK, or not?
What about if we want to upgrade the Informix Server and Client SDK,
do I need to rebuild any thing?
I am a
On 2001-07-08 12:52:45 -0700, Tim Harsch wrote:
> Yes,I realized,thanks. My post is to try to understand speed issues behind
> an existence query. Once I understand that better... then the portability,
> and how that will come into play in DBI, can come next. :-)
>
> So, just to reiterate, wha
This is well of topic, but since I feel like chipping in...
On Win32 with Apache I use #!perl -w. This works only if the perl
executable is in the path - it also has the advantage of allowing
scripts to be easily transfered from one Win32 box to another without
rewriting the shebang. If only
- Bodo Eing <[EMAIL PROTECTED]> on 07/09/01 09:43:41 +0200:
> Date sent:Sat, 7 Jul 2001 20:28:27 +0100
> From: Tim Bunce <[EMAIL PROTECTED]>
> To: [EMAIL PROTECTED]
> Copies to:[EMAIL PROTECTED]
> Subject: (Fwd) .MDX
> Organiz
Date sent: Sat, 7 Jul 2001 20:28:27 +0100
From: Tim Bunce <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Copies to: [EMAIL PROTECTED]
Subject:(Fwd) .MDX
Organization: Paul Ingram Group, Software Systems, +44 1 483
26 matches
Mail list logo