> What's really neat if you do it like that is you can use DBI's
> fetchall_arrayref method and be really snazzy:
>
> my $template = HTML::Template->new( 'filename' => 'file.TMPL' );
> my $sth = $dbh->prepare( <<_SQL_ );
> SELECT val,
> text,
> (if then else to return 'selected' or '') AS selected
> FROM table
> WHERE whatever...
> _SQL_
> $sth->execute();
> $template->param( 'OCCUPATION_LOOP' => $sth->fetchall_arrayref( {} ) );
> ## Note that the fetchall_arrayref doesn't save you computing time --
> ## it's only a shortcut and does the same thing as your loop to go
> ## through the results
> ---
>
> What's neat about this, too is that it simplifies the template code, as
> Puneet laid out.
Except that you have now tied your SQL statement directly to HTML syntax; in which
case... what is the point of using H::T -> you could generate HTML output faster if
you created an SQL statement which generated HTML directly.
The purpose of H::T is to decopule the data from the presentation.
Mathew
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id149&alloc_id66&op=click
_______________________________________________
Html-template-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/html-template-users
