in reply to selectall_hashref
Will that do what you are looking for.my $dbh = DBI->connect('DBI:Sybase:#####', '#####', '#####', { RaiseE +rror => 1, AutoCommit => 1}); my $sql = "select Col1, Col2, Col3 from TABLE where Col4 = 1"; my $data_all = $dbh->selectall_arrayref($sql, { 'Columns' => {} } ); for my $row ( @$data_all ) { print "$_ => $row->{$_}\n" for keys %$row; }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: selectall_hashref
by mnlight (Scribe) on Jan 05, 2006 at 06:43 UTC | |
by Anonymous Monk on Apr 22, 2013 at 14:11 UTC | |
by iza (Monk) on Nov 12, 2014 at 11:00 UTC |