in reply to Creating a hashes from AoHs
or really just (more 'perlish' loop):for ( 0 .. $#fields) { %sql_data = %{$fields[$_]}; ... insert into DB ... }
foreach my $sql_data ( @fields ) { $stmt = qq/INSERT INTO temp_sheet (/ . join(',', keys %$sql_data ) +. qq/) VALUES (/ . join(',', ('?') x keys %$sql_data ) . qq/)/ +; $dbh->do( $sql, {}, values %$sql_data ); }
use SQL::Abstract; my $sql = SQL::Abstract->new; foreach my $data (@fields){ my($stmt, @bind) = $sql->insert('temp_sheet', $data); $dbh->do( $stmt, {}, @bind ); }
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Creating a hashes from AoHs
by bradcathey (Prior) on Mar 03, 2006 at 03:35 UTC |