Re: flattening selectall_hashref results + FetchHashAsRowKey

2003-11-21 Thread Tim Bunce
On Sun, Nov 16, 2003 at 10:11:47AM +, Tim Bunce wrote: > On Sat, Nov 15, 2003 at 08:48:50AM -0800, Terrence Brannon wrote: > > Is there anyway to flatten the results of selectall_hashref ? Here is > > what I had to do in my sub: > > > > sub clans { > > > > my $clan_list = $dbh->selectall_ha

Re: flattening selectall_hashref results + FetchHashAsRowKey

2003-11-16 Thread Tim Bunce
On Sat, Nov 15, 2003 at 08:48:50AM -0800, Terrence Brannon wrote: > Is there anyway to flatten the results of selectall_hashref ? Here is > what I had to do in my sub: > > sub clans { > > my $clan_list = $dbh->selectall_hashref($SQL, 'id'); > > # the "flattening" that I was hoping DBI could d

flattening selectall_hashref results + FetchHashAsRowKey

2003-11-15 Thread Terrence Brannon
Is there anyway to flatten the results of selectall_hashref ? Here is what I had to do in my sub: sub clans { my $clan_list = $dbh->selectall_hashref($SQL, 'id'); # the "flattening" that I was hoping DBI could do somehow :) my @ret; for my $id (sort keys %$clan_list) { push @ret, $clan_l