Re: DBI hashref with multiple db rows

2004-10-05 Thread Wiggins d Anconia
> >> > I have created a module, and inside one of the Package methods, I > >> have > >> > the following code: > >> > > >> > $href = $getPlanInfo->fetchrow_hashref(); > >> > foreach my $key (keys %$href) { > >> > print "$key : $href->{$key}\n"; > >> > $name =

Re: DBI hashref with multiple db rows

2004-10-05 Thread Steve Bertrand
>> > I have created a module, and inside one of the Package methods, I >> have >> > the following code: >> > >> > $href = $getPlanInfo->fetchrow_hashref(); >> > foreach my $key (keys %$href) { >> > print "$key : $href->{$key}\n"; >> > $name = $key; >> >

Re: DBI hashref with multiple db rows

2004-10-05 Thread Wiggins d Anconia
Please bottom post > Steve > > You may want to think of this from a DB perspective. > > Is there a unique key associated with each of these lookups that could prevent duplicate rows being returned? If you are looking up info for a particular person, I would assume you would only want 1 retu

Re: DBI hashref with multiple db rows

2004-10-05 Thread Steve Bertrand
> Steve > > You may want to think of this from a DB perspective. > > Is there a unique key associated with each of these lookups that could > prevent duplicate rows being returned? If you are looking up info for > a particular person, I would assume you would only want 1 returned and > you would wa

Re: DBI hashref with multiple db rows

2004-10-05 Thread jason_normandin
Steve You may want to think of this from a DB perspective. Is there a unique key associated with each of these lookups that could prevent duplicate rows being returned? If you are looking up info for a particular person, I would assume you would only want 1 returned and you would want a key wi