cascade TMPL_LOOP with DBI values

bcochofel has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I'm having trouble with HTML::Template cascading TMPL_LOOP. I have an MySQL table and I'm fetching results to fill one LOOP, this works great. The problem is with a template that has cascading TMPL_LOOP, something like:

<!-- TMPL_LOOP SITES -->
<p><!-- TMPL_VAR NAME="URL" --></p>
<!-- TMPL_LOOP TAGS -->
<p><!-- TMPL_VAR NAME="TAG_NAME" --></p>
<p><!-- TMPL_VAR NAME="TAG_WEIGHT" --></p>
<!-- /TMPL_LOOP -->
<!-- /TMPL_LOOP -->
[download]

My table as the following fields: id, url, tag, weight and usrid. I can have several equal url with diferent tag,weight values, and I want to fill that in the HTML::Template His there any simple way to achieve this? Thanks, Bruno

Comment on cascade TMPL_LOOP with DBI values Download Code

Replies are listed 'Best First'.
Re: cascade TMPL_LOOP with DBI values by tinita (Parson) on Dec 09, 2006 at 21:01 UTC
sure, where's the problem? just fill the following data structure to HTML::Template: `SITES => [ { URL => '...', TAGS => [ { TAG_NAME => 'foo', TAG_WEIGHT => 23 }, { TAG_NAME => 'bar', TAG_WEIGHT => 42 }, ], }, { # second url... }, ]` [download]	[reply] [d/l]
Re: cascade TMPL_LOOP with DBI values by marto (Cardinal) on Dec 09, 2006 at 21:59 UTC
Did you read any documentation before posting this question? Check out Framework, Templating, and Content Management Systems from the Tutorials section of this site. There are a few tutorials that I believe may clear up whatever problems you may have with this. Hope this helps Martin	[reply]
Re: cascade TMPL_LOOP with DBI values by wfsp (Abbot) on Dec 10, 2006 at 07:36 UTC
A similar task was tackled here: HTML::Template nested loops, DBI/MySQL and map Hope that helps.	[reply]
Re^2: cascade TMPL_LOOP with DBI values by bcochofel (Novice) on Dec 10, 2006 at 13:08 UTC
Thanks, I'll give it a try...	[reply]