Hello, I almost have this but cannot figure out why its not showing the data, right now it knows how many entries im putting in because it spits out that number of rows. I am getting my data from dbd::mysql, it works because i have tested in in a normal test.pl and it prints out the data but not using an array or hash. I tried to follow this example: http://search.cpan.org/~samtregar/HTML-Template-2.9/Template.pm#TMPL_LOOP I think its the second loop example on there. Here is my code on the perl side:
my @wall_data = (); while(my $wallref = $wallpostquery->fetchrow_hashref()) { my %walldata; $walldata{WALL_SUBJECT} = $wallref{'SUBJECT'}; $walldata{WALL_DATE} = $wallref{'DATE'}; $walldata{WALL_POSTID} = $wallref{'POSTID'}; $walldata{WALL_MESSAGE} = $wallref{'MESSAGE'}; push (@wall_data, \%walldata); ## i have also tried push @wall +_data, {%walldata}; } $template->param(WALL_LOOP => \@wall_data);
Web side:
<TMPL_LOOP NAME="WALL_LOOP"> <h3><a href="#"><TMPL_VAR NAME='WALL_SUBJECT'> - Posted by <TM +PL_VAR NAME="WALL_POSTID"> on <TMPL_VAR NAME="WALL_DATE"></a></h3> <div id="wallmessage"> <p><TMPL_VAR NAME="WALL_MESSAGE"></p> </div> </TMPL_LOOP>
thanks for those that help, sometimes handling data types is hard for me. -Scott

Node content and title restored by GrandFather


In reply to html::template loops not showing data by tacogrande

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.