OK, one more yes-no. I tried this for performance and as expected, it is
faster than count on MS and Sybase (and count is very fast on MS). You might
see if there is a variation of it you can use with the Oracle Decode
functionI can't answer if there is or not, however in either case even
thou
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 have
absolutely no idea why. I've tried two methods
The uploaded file
Oracle-OCI-0.03.tar.gz
has entered CPAN as
file: $CPAN/authors/id/T/TI/TIMB/Oracle-OCI-0.03.tar.gz
size: 27651 bytes
md5: f51da2b5d44ba4e0b4f58e7c2d1e6378
No action is required on your part
Request entered by: TIMB (Tim Bunce)
Request entered on: Sun, 08 Jul 2001 0
Or change it to 'tar cvf - /opt | gzip -9ckit.tar.gz' and
it will automatically go where you want.
Jared
On Friday 06 July 2001 14:16, Michael A. Chase wrote:
> There doesn't have to be anything magic about /opt. If a client doesn't
> have one, create it. If you tar your kit with 'tar cvf -
Wouldn't that hit every row in the table where xyz = ?, if so could you
short circuit it with an exists or something:
my $statement = q{select 1 from x where exists xyz = ?};
> -Original Message-
> From: Thomas A. Lowery [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, July 07, 2001 4:57 PM
What I do is:
my $statement = q{select 1 from x where xyz = ?};
Prepare:
my $exist_sth = $dbh->prepare( $statement );
Then call selectrow_array with a scalar:
$does_exists = $dbh->selectrow_array($statement, undef, $key_to_check );
Tom
On Fri, Jul 06, 2001
I have put together a script that was intended to move all existing
non-clustered indexes in a SQL 7 database to the secondary filegroup.
However, I am getting unexpected results in a comparison. Here is a snippet
from what I am doing that contains my print statement (To verify that I'm
getting th
- 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 result. Of course, it a
> result of 1 is returned - the row exist
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 result. Of course, it a
result of 1 is returned - the row exists.
Steve H.
-Original Message-
From: Steven Lembark [mailto:[EMAIL
>2. Most UNIX shells do recognize the #! line and will call whatever
>program
>is given there to interpret the file. This works the same whether you are
>using Perl, Bourne Shell, C Shell, Bash, env, or some other program known
>only to you.
Apache on Win32 platforms does the same thing. Give
- Forwarded message from Greg Jackson <[EMAIL PROTECTED]> -
From: Greg Jackson <[EMAIL PROTECTED]>
To: "Tim.Bunce" <[EMAIL PROTECTED]>
Subject: .MDX
Date: Sat, 7 Jul 2001 19:22:52 +0100
Dear Tim
Apologies for unsolicited email, but I have been searching for any
information that will tel
- James Kufrovich <[EMAIL PROTECTED]> on 07/06/01 17:08:56 -0400:
> I'd like to check for the existence of data in a row of a database
> (MySQL), if given the value of a primary key. ("Is there already a row in
> the database that has this value as a key?") I don't care what data is in
>
> -Original Message-
> From: Andreas-Schmitz [mailto:[EMAIL PROTECTED]]
> Sent: Friday, July 06, 2001 7:10 PM
> To: Michael A. Chase
> Cc: [EMAIL PROTECTED]
> Subject: Re: Installing dbi on windows 98
>
>
> Hy Michael,
> > The MSDOS shell ignores the #! line and Perl doesn't worry
> a
- Original Message -
From: "Andreas-Schmitz" <[EMAIL PROTECTED]>
To: "Michael A. Chase" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, July 06, 2001 16:10
Subject: Re: Installing dbi on windows 98
> > The MSDOS shell ignores the #! line and Perl doesn't worry about the
part
>
Hy Michael,
> The MSDOS shell ignores the #! line and Perl doesn't worry about the part
> before 'perl', so it's better to leave it as "#!/usr/bin/perl ..." in case
> you decide later to move to a system with a real shell. The "-wT" is a good
> idea.
Your right! Do not code the perlscript in you
James,
James Kufrovich wrote:
>
> Hi.
>
> I'd like to check for the existence of data in a row of a database
> (MySQL), if given the value of a primary key. ("Is there already a row in
> the database that has this value as a key?") I don't care what data is in
> the row, or if more tha
16 matches
Mail list logo
