Hi,
I am facing problem installing DBI in cygwin. Please see the steps I followed:
1. I am running Cygwin dll version 1.5.12.1.My Cygwin Perl version is 5.8.6.
I have downloaded and installed mysql server version 4.0.23 on my Win XP
m/c.
Started the server and tested it successfully.
Is there another way of fetching all table records in one statement
without going through a loop?
What I have now is as follows:
while (@eachrec=$sth-fetchrow_array) {
do whatever;
}
I want to retrieve all the records into an array first and process it
later on. What would
The simplest is $dbh-selectrow_arrayref().
It's documented in the DBI man page.
-Will
-Original Message-
From: Tiffany Thang [mailto:[EMAIL PROTECTED]
Sent: Friday 25 February 2005 12:23
To: dbi-users@perl.org
Subject: how to fetch all records
Is there another way of fetching all
Whoops. I mean selectall_arrayref() (for the general case).
-Will
-Original Message-
From: Rutherdale, Will
Sent: Friday 25 February 2005 12:26
To: dbi-users@perl.org
Subject: RE: how to fetch all records
The simplest is $dbh-selectrow_arrayref().
It's documented in the DBI man
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Feb 25, 2005, at 9:22 AM, Tiffany Thang wrote:
Is there another way of fetching all table records in one statement
without going through a loop?
What I have now is as follows:
while (@eachrec=$sth-fetchrow_array) {
do whatever;
}
I want to
Note: I posted this on another list a few minutes ago only to realize
seconds after posting that it wasn't the right list. So if you are
subscribed to that list also and see this as a duplicate, I apologize
in advance.
I am running MySQL 4.1.10 and ActivePerl 5.8.6.811 on Windows 2003.
When I
I'm always cautious of slurping (files or result sets) like that.
Depending on the size of your result set, that can wind up being a huge
array, which of course is then held in memory until it's discarded, or
until the program ends. If it's only a few thousand rows, go for it, but
if it's a
On Fri, 25 Feb 2005, Jason Johnson wrote:
Note: I posted this on another list a few minutes ago only to realize
seconds after posting that it wasn't the right list. So if you are
subscribed to that list also and see this as a duplicate, I apologize
in advance.
I am running MySQL 4.1.10
Rudy Lippan said:
On Fri, 25 Feb 2005, Jason Johnson wrote:
Note: I posted this on another list a few minutes ago only to realize
seconds after posting that it wasn't the right list. So if you are
subscribed to that list also and see this as a duplicate, I apologize
in advance.
I am
On Fri, 25 Feb 2005 13:01:04 -0800 (PST), William R. Mussatto wrote:
Hi Jason
I am running MySQL 4.1.10 and ActivePerl 5.8.6.811 on Windows
2003. When I upgraded MySQL from an older version, everything
using DBD-MySQL complained about not being compatible and
MySQL is telling me to upgrade
10 matches
Mail list logo