The same example, using Pg...
# use Pg;
# my $dbh = Pg::connectdb(dbname=dbname);
# my $sth = $dbh-exec(SQL STATEMENT);
# for (my $i = 0; $i $sth-ntuples; $i++) {
# for (my $j = 0; $j $sth-nfields; $j++) {
#print Value at ($i,$j):
$sth-getvalue($i,$j)\n;
# }}
It is more concise, and more
Yes, you are right. Sorry.
Need Mail bonding?
Go to the Yahoo! Mail QA for great tips from Yahoo! Answers users.
http://answers.yahoo.com/dir/?link=listsid=396546091
Hi Bob,
- Forwarded message from Bob Hunter [EMAIL PROTECTED]
-
Date: Tue, 27 Feb 2007 08:03:19 -0800 (PST)
From: Bob Hunter [EMAIL PROTECTED]
Subject: DBI's method for reading [row x,field y]
Tim,
I am porting an application from Pg to DBI, and make extensive use of
the
Tim Bunce wrote:
- Forwarded message from Bob Hunter [EMAIL PROTECTED] -
Date: Tue, 27 Feb 2007 08:03:19 -0800 (PST)
From: Bob Hunter [EMAIL PROTECTED]
Subject: DBI's method for reading [row x,field y]
To: Tim Bunce [EMAIL PROTECTED]
X-Pobox-Pass: [EMAIL PROTECTED] is whitelisted
Tim,
The list is dead. Forwarding the message to the list
is like dropping it in the bin. If you do not care
meeting user's problems, then why should I care using
DBI in the first place? I have your book, it is
verbose, but it does not answer to key questions.
Either you write a better book, or start
As far as I can see, this feature is not documented,
neither in perldoc DBI nor in Bunce's book. You seem
to know DBI better than the author...
Thank you.
Bob
Bored stiff? Loosen up...
Download and play
Bob Hunter wrote:
The list is dead. Forwarding the message to the list
is like dropping it in the bin. If you do not care
meeting user's problems, then why should I care using
DBI in the first place? I have your book, it is
verbose, but it does not answer to key questions.
Either you write a
Bob Hunter [mailto:[EMAIL PROTECTED] wrote:
The list is dead. Forwarding the message to the list
is like dropping it in the bin. If you do not care
meeting user's problems, then why should I care using
DBI in the first place? I have your book, it is
verbose, but it does not answer to key
-Original Message-
From: Bob Hunter [mailto:[EMAIL PROTECTED]
Sent: Tue 2/27/2007 5:07 PM
To: Garrett, Philip (MAN-Corporate); dbi-users@perl.org
Cc: [EMAIL PROTECTED]
Subject: RE: (Fwd) DBI's method for reading [row x,field y]
The same example, using Pg...
# use Pg;
# my $dbh
Martin J. Evans wrote:
Of course, selectall/fetchall_arrayref retrieves all the rows in the
result-set so this will use that amount of memory up but given you are
already doing this I guess that won't bother you (unless Pg uses cursors
to navigate to the required row). To my knowledge, DBI
10 matches
Mail list logo