Greetings, been a DBI user for years now working with stuff from
unixODBC, Oracle, MySQL, etc...etc...
So, the issue I'm having is with a simple update statement to a mysql
database.
Here's a small snippet of code
my $MAPSQL=UPDATE varmaptest SET value=? WHERE grpid=(SELECT id FROM
On Sep 13, 11:16 am, mark.bo...@proquest.com (Bobak, Mark) wrote:
Does anyone have any experience w/ doing two-phase commit across connections
to two different databases from the same Perl program? (To guarantee that
either both or neither transaction is committed, for consistency.)
Any
On Oct 7, 1:59 am, martin.h...@oracle.com (Martin Hall) wrote:
Just a thought - but how are you checking the update? Just after the
statement in the same Perl code or in a separate session?
Cheers
Martin
On 06/10/2011 23:04, Eirik Toft wrote:
Greetings, been a DBI user
On Oct 7, 6:43 am, g...@turnstep.com (Greg Sabino Mullane) wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
my $dbh = DBI-connect($SQLDS,$DBUSER,$DBPASS);
It's always a good idea to explictly set AutoConnect here.
I also like to set PrintError=0 and RaiseError=1
So, for some
On Oct 6, 3:04 pm, grep_...@yahoo.com (Eirik Toft) wrote:
Greetings, been a DBI user for years now working with stuff from
unixODBC, Oracle, MySQL, etc...etc...
So, the issue I'm having is with a simple update statement to a mysql
database.
Here's a small snippet of code
my $MAPSQL