-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hey Peter,
Are you sure about that?
As far as I understand, what you say you can't do, is to have two
prepares for example:
my $dbh = DBI->connect("dbi:mysql:database","user","pass");
my $foo = $dbh->prepare("SELECT * FROM .....");
my $bar = $dbh->prepare("INSERT INTO .....");
$foo->execute();
$foo->finish();
$bar->execute();
$bar->finish();
At least that works for me.
Sorry if I misunderstood you.
Mads
Peter Rabbitson wrote:
|>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
|
|
- --
Mads N. Vestergaard - http://rwxr-xr-x.dk
Interested in Open Source, and web application development
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)
iD8DBQFC0Ukt7WOaPMd53OMRAvcCAJ0Y/kCn1Oh67D3AUrCfpq7ihBOu8QCeO/SC
JMvYjVK+8naZfgReXn13AQU=
=psBJ
-----END PGP SIGNATURE-----
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
<http://learn.perl.org/> <http://learn.perl.org/first-response>
