Search for specific field rather than primary key

[prev] [thread] [next] [Date index for 2004/08/12]

Hello everyone,

I'm just curious if the code below that looks in the
Pilot::StoreBrandXref table for a particular store, and has an
iterator created in order to get to the brandid field.

my $bds = Pilot::StoreBrandXref->search({store => $store});

while (my $k = $bds->next) {
        push @{$form_data{brand}}, $k->brandid;
}
print join(",", @{$form_data{brand}}), "<br>";

If I were to say:

my @bds = Pilot::StoreBrandXref->search({store => $store});

the bds array would be an array of the primary keys with store
matching my search.

Is there not a way for me to specify the field I'd like returned
rather than having to create an iterator to get to the field I'd like
to?

Any help is appreciated,
Kevin
        -- 
        Kevin Old
kevinold@xxxxx.xxx