[dancer-users] list order from a hash

[Richard Reina]

Hi Andrew,

the {} did the trick. Thank you VERY much. Was going out of my mind.

2015-08-26 13:04 GMT-05:00 Andrew Beverley <andy at andybev.com>:

> On Wed, 2015-08-26 at 12:39 -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.
> >
> > 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.
>
> You might need to do:
>
>     $sth->fetchall_arrayref({})
>
> Sorry, it's been a while since I've done direct DBI calls. I'd recommend
> checking
> out DBIx::Class if you have the time.
>
> If you're still not having any luck, dump the result to see what you've
> got:
>
>     use Data::Dumper;
>     say STDERR Dumper $Jobs_ref;
>
> Be careful of case-sensitivity, that could cause you problems too.
>
> Andy
>
>
>
> _______________________________________________
> 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/6d9652b9/attachment.html>