On Fri, May 04, 2001 at 04:49:59PM -0600, Peter J. Schoenster wrote: > > eval { > my $sql = qq|INSERT INTO company_profile > (company_description,company_name,culture,employees,employer > _id,growth_rate,leadership,mission,sec_fillings_url,type,url,year) > VALUES(?,?,?,?,?,?,?,?,?,?,?,?)|; > my @vals = qw(sadfds 007_company_name sadfsadfsa 500 47 > 91-100% sadfsad afsadf sdfdsa established sadfsadf 1965); > my $sth; > $sth= $dbh->prepare($sql); > $sth->execute(@vals); > > $sql = qq|UPDATE users set username = 'NOT' where f_id = ?|; > $sth= $dbh->prepare($sql); > $sth->execute('49'); > > $sth->finish(); > $dbh->commit; > }; Out in the unix world there's a "Useless use of the cat command" award. I should probably invent one for "Useless use of the finish method". Ho hum. Meanwhile, maybe the next release of the DBI will rename finish() to cancel_select() and deprecate finish(). Tim.
- Re: executing atomic transactions in DBI Stephen Clouse
- RE: executing atomic transactions in DBI Sterin, Ilya
- RE: executing atomic transactions in ... Peter J. Schoenster
- RE: executing atomic transaction... Bodo Eing
- Re: executing atomic transac... Stephen Clouse
- Re: executing atomic transac... Michael A Mayo
- Re: executing atomic transac... Bodo Eing
- Re: executing atomic transactions in ... Randal L. Schwartz
- Re: executing atomic transaction... Chip Turner
- Re: executing atomic transactions in ... Stephen Clouse
- Re: executing atomic transactions in DBI Tim Bunce
- Re: executing atomic transactions in DBI Michael A. Chase
- RE: executing atomic transactions in DBI Sterin, Ilya
- RE: executing atomic transactions in DBI Sterin, Ilya
- Re: executing atomic transactions in DBI Randal L. Schwartz
- RE: executing atomic transactions in DBI Sterin, Ilya
- RE: executing atomic transactions in DBI Neil Lunn
- RE: executing atomic transactions in DBI Bodo Eing
- RE: executing atomic transactions in DBI Neil Lunn
- RE: executing atomic transactions in DBI Sterin, Ilya
- Re: executing atomic transactions in DBI Tim Bunce