[dancer-users] list order from a hash
Richard Reina
gatorreina at gmail.com
Wed Aug 26 18:39:09 BST 2015
Andrew and Attilla,
Thank you for the replies. I am guessing that keeping the sorting in the
SQL instead of the HTML would mean the page would load faster so I trying
to go that route.
However, when I switch my code above to:
<% FOREACH job in Jobs %>
<option value="<% job.ID %>"><% Job.NAME %></option>
<% END %>
I get an empty dropdown. I am using $sth->fetchall_arrayref(); with no
arguments. Sorry to ask, but been playing with it for over an hour and
still have it figured it out.
2015-08-26 9:04 GMT-05:00 Andrew Beverley <andy at andybev.com>:
> On Wed, 2015-08-26 at 08:51 -0500, Richard Reina wrote:
> > I have this table data that I load into a template as follows.
> >
> > $q = "SELECT ID, NAME
> > FROM jobs
> > ORDER BY NAME";
> > $sth = $dbh->prepare($q);
> > $sth->execute();
> > my $Jobs_ref = $sth->fetchall_hashref('ID');
>
> use fetchall_arrayref() instead.
>
> > To display it in the template as a drop-down select I do:
> >
> > <select class="selectpicker" name="jobselect" id="jobselect"
> > style="width: 500px;">
> > <% FOREACH ID IN Jobs.keys %>
>
> Here you just need something like
>
> FOREACH job in Jobs
>
> > <option value="<% Jobs.$ID.ID %>"><% Jobs.$ID.NAME %></option>
>
> And then here use job.ID, job.NAME etc.
>
> > And it works great. Except for one thing, the list is not in order by
> name.
> > I have read more than a few posts about how once you save a query as a
> > hashref that the order is lost.
>
> Yes, in Perl arrays are ordered, hashes are not. If you want to retain
> order, you
> must use an array (or sort the hash before use, which is expensive).
>
> > Most of those posts suggested fetching as a
> > arrayref instead. However, I have no idea how to do that and then display
> > it in a select like the above code does.
>
> See above.
>
>
> _______________________________________________
> dancer-users mailing list
> dancer-users at dancer.pm
> http://lists.preshweb.co.uk/mailman/listinfo/dancer-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.preshweb.co.uk/pipermail/dancer-users/attachments/20150826/e62d221a/attachment.html>
More information about the dancer-users
mailing list