Re^3: Template::Toolkit - How do i access alias-based results?

in reply to Re^2: Template::Toolkit - How do i access alias-based results?
in thread Template::Toolkit - How do i access alias-based results?

Sorry, try this then ;) Not sure if its 'IN' or '=' in this FOR loop, try both if needed.

[% USE oracleDB = DBI("dbi:Oracle:xe", "LP", "lpdba") %]
<html>
<body>

[% query = oracleDB.prepare("
SELECT u.name, u.adress, u.idontknow    
FROM user u, anothertable t, athirdtable d
WHERE u.id = t.user
AND t.id = d.something
ORDER BY u.name DESC") %]

[% USE Dumper %]

[% FOREACH res IN query.execute() %]
<pre>
[% Dumper.dump(res) %]
</pre>
[% END %]

</body>
</html>
[download]

This is not a Signature...

Comment on Re^3: Template::Toolkit - How do i access alias-based results? Download Code

In Section Seekers of Perl Wisdom