in reply to Re^4: How do I cope with nested TMPL_VAR in HTML::Template::Pro?
in thread How do I cope with nested TMPL_VAR in HTML::Template::Pro?

show tables just returns one column. You can just do something like

my @loop; while (my @cols = $sth->fetchrow_array) { push @loop, { table_name => $cols[0] }; } $tmp->param(loop => \@loop);

There you go, fixed name (table_name) to pass to your template.

P.S. if you had provided enough context from the very beginning, it would have been much easier to help you straight away.

Replies are listed 'Best First'.
Re^6: How do I cope with nested TMPL_VAR in HTML::Template::Pro?
by PerlOnTheWay (Monk) on Aug 03, 2011 at 15:15 UTC

    I can't,cause I'm using another encapsulated DB interface which essentially just return the result of $sth->fetchall_array.

    Of course I can blend it again, but it's also bringing overhead,right?

    Is there a way to do the real nested TMPL_VAR thing?