That said, my philosophy is to dump as much work on the database as possible. Why? -- because db programs have been developed over years and years (not that Perl has not been, but your or my code may not have the same advantage), db servers are typically fast machines, db software have been honed to do set processing, evaluations, calculations, etc. There is a lot of science behind db theory. Definitely use it to your advantage.
I definitely agree here -- I didn't think about using SQL to do the selected part ... kinda neat. :)
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.
Cheers,
Jason
-------------------------------------------------------
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_id=3149&alloc_id=8166&op=click
_______________________________________________
Html-template-users mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/html-template-users
