[Chicago-talk] Concactenate results from perl DBI fetchall_hashref

richard at rushlogistics.com richard at rushlogistics.com
Sun Aug 23 15:35:19 PDT 2015

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);
       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. 

More information about the Chicago-talk mailing list