> I'm sure others will give you more informed answers.. But why can't > you create multiple statement handlers under the same connection? >
Because you can't. One connection holds only one prepared statement (at least in MySQL). If you prepare $statement2 on the same $dbh, $statement1 automatically gets invalidated. Clinically proven :) Peter -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>