Concerning stale data, depending on your application's design, you might
want to set AutoCommit to 0 (off). You can do this as an option in
connect, like this:
my $dbh = DBI->connect( ... { AutoCommit => 0 } );
Once you do this, the underlying database will treat all your DB
operations as a sing
Your best bet (and fastest) would be to use
fetchall_arrayref()
like this
my $sth = $dhh->prepare("select * from my_countries");
$sth->execute();
my $reff_array = $sth->fetchall_arrayref();
then you can use $ref_array anyway you want without going back to the DB.
foreach my $row (@
On Fri, Jun 23, 2006 at 08:45:20AM -0700, Brad Kroeger wrote:
> Hello,
>
> I'm having problems building DBD 1.51 on Solaris 9. I have not found
> anything in google that has helped with with this problem, aside from
> that I should be using a compiler that was built on Solaris 9.
>
> I needed