[Chicago-talk] Concactenate results from perl DBI fetchall_hashref

[richard at rushlogistics.com]

I fetch the following rows as follows

       my $q = "SELECT ID, NAME, descrip
                FROM accomp_type 
                WHERE repair = ?
                ORDER BY NAME";
       my $sth = $dbh->prepare($q);
       $sth->execute($rep_id);
       my $accomp_ref = $sth->fetchall_hashref('ID'); 
     
       I would like to combine NAME and descrip into NAME so that in my page when
       I do:
                 <label><input type="checkbox" value="<% Accomp.$ID.ID %>"><% Accomps.$ID.NAME %></label>

Name and description will appear instead of the name only. Can anyone tell me how I can accomplish this?

Thanks for any help.