Let's close this thread now. Thanks.
Tim.
> which ultimately makes the
> 50 or
> 60 line script you sent originally about 10 lines or less. (IE by
> using
> the array of array setup instead of some convoluted matrix that is
> structured god know how.
>
> That means in six months when you (or heaven forbid me) have to
> maintain
> y
listmail wrote:
Well I'm not seeing why a number of arrays that each point to arrays
could not be consider a matrix of arrays when considering one definition
of the word matrix "Something resembling such an array, as in the
regular formation of elements into columns and rows". I dunno, i'm n
riday 18 November 2005 09:59
To: dbi-users@perl.org
Subject: Re: anyway to determine # rows before fetch loop ends and without
seperate count(*)
Well I'm not seeing why a number of arrays that each point to arrays
could not be consider a matrix of arrays when considering one definition
o
listmail [mailto:[EMAIL PROTECTED] wrote:
>
> Well I'm not seeing why a number of arrays that each point to arrays
> could not be consider a matrix of arrays when considering one definition
> of the word matrix "Something resembling such an array, as in the
> regular formation of elements into c
Well I'm not seeing why a number of arrays that each point to arrays
could not be consider a matrix of arrays when considering one definition
of the word matrix "Something resembling such an array, as in the
regular formation of elements into columns and rows". I dunno, i'm not
trying to argue
Also very convoluted, all of that can be done with:
my $results = $dbh->selectall_arrayref($sql); # if you only want
to
process a certain amount just LIMIT in your $sql...
I appreciate the response. I tested selectall_arrayref and as I
expected, irregardless of the number of rows returned
> [EMAIL PROTECTED] wrote:
>
> > #Here's an example which shows what I am trying to accomplish.
> If I
> > can determine the number of rows before pushing the data, this
> can
> > simply things for #me when processing the data throught my
> scripts.
> > #
> > use warnings;
> > use strict;
s over this issue on the list before.
-Will
-Original Message-
From: Rob Craig [mailto:[EMAIL PROTECTED]
Sent: Wednesday 16 November 2005 17:19
To: [EMAIL PROTECTED]
Cc: dbi-users@perl.org
Subject: Re: anyway to determine # rows before fetch loop ends and without
seperate count(*)
I am using D
On 11/16/05, Rob Craig <[EMAIL PROTECTED]> wrote:
> I am using DBD::mysql and I can get the number of rows by assigning the
> result of the execute to a scalar:
>
> my $rows = $sth->execute or die "Couldn't execute statement: " .
> DBI->errstr;
>
> maybe this doesn't work with DBD::Oracle?
>
>
[EMAIL PROTECTED] wrote:
#Here's an example which shows what I am trying to accomplish. If I
can determine the number of rows before pushing the data, this can
simply things for #me when processing the data throught my scripts.
#
use warnings;
use strict;
Good good :)
use DBI;
use DBD
I am using DBD::mysql and I can get the number of rows by assigning the
result of the execute to a scalar:
my $rows = $sth->execute or die "Couldn't execute statement: " .
DBI->errstr;
maybe this doesn't work with DBD::Oracle?
Rob
[EMAIL PROTECTED] wrote:
#Here's an example which shows w
Subject: anyway to determine # rows before fetch loop ends and without
seperate count(*)
#Here's an example which shows what I am trying to accomplish. If I
can determine the number of rows before pushing the data, this can
simply things for #me when processing the data throught my sc
#Here's an example which shows what I am trying to accomplish. If I
can determine the number of rows before pushing the data, this can
simply things for #me when processing the data throught my scripts.
#
use warnings;
use strict;
use DBI;
use DBD::Oracle;
my $sql=q{ select name, location
14 matches
Mail list logo