in reply to using sequences with dbi
I would guess either you don't have the ?'s in the prepare, or the Database driver (DBD) you are using does not support them. you really need to post the error and relevant code if you want more than that.my $sth = $dbh->prepare('INSERT INTO table (foo,bar) VALUES (?,?)'); foreach my $value (keys %huge_data_set_to_insert) { $sth->execute($huge_data_set_to_insert{$value},$value); } $sth->finish();
|
|---|