<div dir="ltr"><div><div>Imran,<br><br></div>Thank you very much for your reply. Your first solution worked perfectly.<br><br></div>Thanks again.<br></div><div class="gmail_extra"><br><div class="gmail_quote">2015-08-24 11:26 GMT-05:00 imran javaid <span dir="ltr"><<a href="mailto:imranjj@gmail.com" target="_blank">imranjj@gmail.com</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">There is more than one way to skin this cat.<div><br><div>Did you try this?</div><div><span style="font-size:12.8000001907349px"><label><input type="checkbox" value="<% Accomp.$</span><a href="http://id.id/" rel="noreferrer" style="font-size:12.8000001907349px" target="_blank">ID.ID</a><span style="font-size:12.8000001907349px"> %>"><% Accomps.$</span><a href="http://id.name/" rel="noreferrer" style="font-size:12.8000001907349px" target="_blank">ID.NAME</a><span style="font-size:12.8000001907349px"> %></span><span style="font-size:12.8000001907349px"><% Accomps.$</span><a href="http://id.name/" rel="noreferrer" style="font-size:12.8000001907349px" target="_blank">ID.</a>descrip<span style="font-size:12.8000001907349px"> %></span><span style="font-size:12.8000001907349px"></label></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">or you could change query:</span></div><div><span style="font-size:12.8000001907349px">my $q = "SELECT ID, NAME, descrip, NAME || descrip as COMBINED</span><span class=""><br style="font-size:12.8000001907349px"><span style="font-size:12.8000001907349px"> FROM accomp_type</span><br style="font-size:12.8000001907349px"><span style="font-size:12.8000001907349px"> WHERE repair = ?</span><br style="font-size:12.8000001907349px"><span style="font-size:12.8000001907349px"> ORDER BY NAME";</span><span style="font-size:12.8000001907349px"><br></span></span></div><div><span style="font-size:12.8000001907349px">and refer to it as:</span></div><div><span style="font-size:12.8000001907349px"><label><input type="checkbox" value="<% Accomp.$</span><a href="http://id.id/" rel="noreferrer" style="font-size:12.8000001907349px" target="_blank">ID.ID</a><span style="font-size:12.8000001907349px"> %>"><% Accomps.$</span><a href="http://id.name/" rel="noreferrer" style="font-size:12.8000001907349px" target="_blank">ID.</a>COMBINED<span style="font-size:12.8000001907349px"> %></label></span><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">Note that in either case, there is no space between NAME and descrip. You can add that if you want.</span></div><span class="HOEnZb"><font color="#888888"><div><span style="font-size:12.8000001907349px"><br></span></div><div><span style="font-size:12.8000001907349px">-imran</span></div></font></span></div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Sun, Aug 23, 2015 at 5:35 PM, <span dir="ltr"><<a href="mailto:richard@rushlogistics.com" target="_blank">richard@rushlogistics.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I fetch the following rows as follows<br>
<br>
my $q = "SELECT ID, NAME, descrip<br>
FROM accomp_type<br>
WHERE repair = ?<br>
ORDER BY NAME";<br>
my $sth = $dbh->prepare($q);<br>
$sth->execute($rep_id);<br>
my $accomp_ref = $sth->fetchall_hashref('ID');<br>
<br>
I would like to combine NAME and descrip into NAME so that in my page when<br>
I do:<br>
<label><input type="checkbox" value="<% Accomp.$<a href="http://ID.ID" rel="noreferrer" target="_blank">ID.ID</a> %>"><% Accomps.$<a href="http://ID.NAME" rel="noreferrer" target="_blank">ID.NAME</a> %></label><br>
<br>
Name and description will appear instead of the name only. Can anyone tell me how I can accomplish this?<br>
<br>
Thanks for any help.<br>
<br>
_______________________________________________<br>
Chicago-talk mailing list<br>
<a href="mailto:Chicago-talk@pm.org" target="_blank">Chicago-talk@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/chicago-talk" rel="noreferrer" target="_blank">http://mail.pm.org/mailman/listinfo/chicago-talk</a></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Chicago-talk mailing list<br>
<a href="mailto:Chicago-talk@pm.org">Chicago-talk@pm.org</a><br>
<a href="http://mail.pm.org/mailman/listinfo/chicago-talk" rel="noreferrer" target="_blank">http://mail.pm.org/mailman/listinfo/chicago-talk</a><br></blockquote></div><br></div>