UPDATE statements causing me grief!

2011-10-07 Thread Eirik Toft
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

Re: Oracle and Two Phase commit with Perl?

2011-10-07 Thread Eirik Toft
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

Re: UPDATE statements causing me grief!

2011-10-10 Thread Eirik Toft
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

Re: UPDATE statements causing me grief!

2011-10-10 Thread Eirik Toft
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

Re: UPDATE statements causing me grief!

2011-10-10 Thread Eirik Toft
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