the answer is yes (which is probably the answer you anticipated) the other question is how many connection handles can you have? for implementation characteristics you will want to look at (your language package) for 'Database Connection Pools'
Viel Gluck Martin ______________________________________________ Disclaimer and confidentiality note Everything in this e-mail and any attachments relates to the official business of Sender. This transmission is of a confidential nature and Sender does not endorse distribution to any party other than intended recipient. Sender does not necessarily endorse content contained within this transmission. > Date: Fri, 21 Nov 2008 12:32:04 +0100 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > CC: [email protected] > Subject: Re: Beginners Question: Can I have more the one statement-handle > from same db-handle at a time? > > Yes. > > Deviloper schrieb: > > like: > > > > my $db->connect(blablabla); > > my $sth1 = $db->prepare("select * from animals"); > > $sth1->execute(); > > my $sth2 = $db->prepare("select * from pets"); > > $sth2->execute(); > > my $sth3 = $db->prepare("select * from fish"); > > $sth... > > > > while (my ($animal) = $sth2->fetch_array) { > > ... > > } > > > > I can´t test myself because my the mysql db on my iphone > > is broken and I have no other here at the moment :-( > > > > A simple yes or no will do. > > Thanks, > > B. > > > > -- > > =================================== > Robert Roggenbuck > Universitaetsbibliothek Osnabrueck > Alte Muenze 16 > D-49074 Osnabrueck > Germany > Tel ++49/541/969-4344 Fax -4482 > [EMAIL PROTECTED] > > Postbox: > Postfach 4496 > D-49034 Osnabrueck > =================================== _________________________________________________________________ Proud to be a PC? Show the world. Download the “I’m a PC” Messenger themepack now. hthttp://clk.atdmt.com/MRT/go/119642558/direct/01/
