Re: DBI and fetchall

Replies are listed 'Best First'.
Re^2: DBI and fetchall_arrayref by mje (Curate) on Feb 20, 2009 at 13:24 UTC
and don't forget to set RaiseError or check $sth->err afterwards because if fetchrow_arrayref fails it can still return rows. See http://search.cpan.org/~timb/DBI-1.607/DBI.pm#fetchall_arrayref	[reply]
Re^2: DBI and fetchall_arrayref by jethro (Monsignor) on Feb 19, 2009 at 17:57 UTC
Small correction: `print $result->[0]->{'b'}."\n";`	[reply] [d/l]
Re^3: DBI and fetchall_arrayref by grinder (Bishop) on Feb 20, 2009 at 12:04 UTC
Small correction Actually, `$result->[0]{b}` will work just fine as well. You don't need to dereference explicitly after the first one, nor do bareword keys need to be quoted. Concision, concision! • another intruder with the mooring in the heart of the Perl	[reply] [d/l]
Re^3: DBI and fetchall_arrayref by Anonymous Monk on Feb 25, 2009 at 14:14 UTC
you don't even need arrows or periods :) `#!/usr/bin/perl -- use strict; use warnings; my $result = [ { b => 'small erection' } ]; print $result->[0]->{'b'}."\n"; print $result->[0]{b}."\n"; print "$$result[0]{b}\n"; print "$result->[0]{b}\n"; __END__ small erection small erection small erection small erection` [download]	[reply] [d/l]
Re^4: DBI and fetchall_arrayref by Anonymous Monk on May 04, 2009 at 14:09 UTC
See perldoc DBI	[reply]
Re^5: DBI and fetchall_arrayref by Anonymous Monk on May 04, 2009 at 14:11 UTC