Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

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

by Yaerox (Scribe)
on Jul 13, 2015 at 13:18 UTC ( #1134496=note: print w/replies, xml ) Need Help??


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

# DB - Connect my $hDB = DBI->connect( "dbi:Oracle:dbname", "dbusername", "dbuserpass +wort", { AutoCommit => 0 } ); my $hStatement = $hDB->prepare("MY SQL HERE"); $hStatement->execute( ); while ( ( $var1, $var2, $var3) = $hStatement->fetchrow_array ){ push( @aRows, ( $var1, $var2, $var3 ) ); } $hStatement->finish; $hDB->disconnect; print Dumper( @aRows );
output
$VAR1 = '11000530'; $VAR2 = '8041094A'; $VAR3 = 'Eingelesen'; $VAR4 = +'09-JUL-15'; $VAR5 = '528';
Imo this shouldn't be interesting at all. The question is, how to access resultset when using joings on TT ...

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1134496]
help
Chatterbox?
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2017-12-12 01:53 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    What programming language do you hate the most?




















    Results (323 votes). Check out past polls.

    Notices?