On Tue, Dec 11, 2001 at 04:14:27PM -0800, Matisse Enzer wrote:
> It is true that selectall_hashref returns the same thing as this
> modules' FetchAll method - the difference is that the FetchAll method
> will call
> Carp::confess if the DBI prepare or execute methods fail.
>
> Perhaps this isn't worth it - DBI->trace could be turned on for example.
The DBI will soon be getting a hook so you can call your own code
instead of PrintError/RaiseError.
Tim.
> At 9:33 AM -0800 12/11/01, Terrence Brannon wrote:
> >On Monday, December 10, 2001, at 11:45 PM, Matisse Enzer wrote:
> >
> >>Hi folks.
> >
> >Hi Matisse.
> >
> >>
> >>I'm looking for feedback on this...
> >>
> >>
> >>You would write:
> >>
> >> my $sql = "SELECT name,address FROM $table WHERE zipcode=?";
> >> my $found_rows = $wrapper->FetchAll("$sql","$zipcode");
> >> # $found_rows is an array_ref of hash_refs
> >>
> >
> >This seems to be covered by the standard DBI method
> >selectall_hashref. I actually missed it, because I was searching for
> >fetchall_hashref (any possibility of that becoming a synonym, Tim?)
>
> --
> -------------------------------------------
> Matisse Enzer
> [EMAIL PROTECTED]
> http://www.matisse.net/