Gerald Host wrote:
>
> Rob Dixon wrote:
>
>> You don't want to use selectall_hashref because, as is the nature of hashes,
>> the key must be unique, which means the database table's key field that
>> provides it must also be unique. If you get this working, you will retrieve a
>> single record for
Gerald Host wrote:
> I'm using DBI's selectall_hashref with 5 key columns. I want to display
> each row where key col 1 is 'yes' or NULL (undef or '' ?)
>
>
> foreach my $medCategory (keys %{$href->{'yes'}->{qw('' 'yes')}->{qw(''
> 'yes')}}) {
> foreach my $med (keys %{$href->{qw('yes')}->{
Ryan/Gerald (!)
(Ryan)
You don't want to use selectall_hashref because, as is the nature of hashes,
the
key must be unique, which means the database table's key field that
provides it
must also be unique. If you get this working, you will retrieve a single
record
for each possible value of
Gerald Host wrote:
>
> I'm using DBI's selectall_hashref with 5 key columns. I want to display
> each row where key col 1 is 'yes' or NULL (undef or '' ?)
>
>
> foreach my $medCategory (keys %{$href->{'yes'}->{qw('' 'yes')}->{qw(''
'yes')}}) {
> foreach my $med (keys %{$href->{qw('yes')}->{qw(
