Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Reading complex result-sets in Catalyst/Template

by thundergnat (Deacon)
on May 18, 2012 at 16:37 UTC ( #971337=note: print w/ replies, xml ) Need Help??


in reply to Reading complex result-sets in Catalyst/Template

Update: Clarified some ambiguities.

I can't see any reason why that (template) code wouldn't work. It works for me locally (with some mocked up data in a structure as you described.) The headers are in the wrong position but you just need to shift them around a bit. See if this works for you locally. If this works for you, I suspect the data structure you are getting from your database query is not what you think it is in your program.

Generates a file named test.html. Open it with a browser.

use strict; use warnings; use Template; my $tt = Template->new(); my $data = [ { city => 'thiscity', country => 'thiscountry', lat => 'thislat', long => 'thislong', name_urls => [ [ '', 'info1', 'info2', '', '', ['url1','url2','ur +l3']], [ '', 'info3', 'info4', '', '', ['url5','url6','ur +l7']] ] }, { city => 'thatcity', country => 'thatcountry', lat => 'thatlat', long => 'thatlong', name_urls => [ [ '', 'info1', 'info2', '', '', ['url1','url2','ur +l3']], [ '', 'info3', 'info4', '', '', ['url5','url6','ur +l7']] ] }, ]; $tt->process(\*DATA, {types => $data}, 'test.html') or die $tt->error( +), "\n"; __DATA__ [% USE Dumper -%] <table border='1'> <tr><th>City/Locale</th><th>Country code</th><th>latitude</th><th>long +ditude</th><th>Identity details</th></tr> [% FOREACH type IN types -%] <tr> <td><table style="border: solid red 1px">[% FOREACH nu IN type.nam +e_urls %] <tr> <td> [% nu.1 %] </td> <td> [% nu.2 %] </td> <td><ul> [% FOREACH id IN nu.5 %] <li style="border: solid navy 1px">[% id %]</li> [% END -%] </ul></td> </tr> [% END -%] </table></td> <td>[% type.city %]</td> <td>[% type.country %]</td> <td>[% type.lat %]</td> <td>[% type.long %]</td> </tr> [% END -%]


Comment on Re: Reading complex result-sets in Catalyst/Template
Download Code

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://971337]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2015-07-29 02:40 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (260 votes), past polls