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 for
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
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
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 for years now working with stuff from
unixODBC, Oracle, MySQL, etc...etc...
So, the
-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 reason, the update never happens, and I get no errors.
Try changing it
Eirik Toft grep_...@yahoo.com wrote on 10/06/2011 05:04:10 PM:
Eirik Toft grep_...@yahoo.com
10/07/2011 03:51 AM
To
dbi-users@perl.org
cc
Subject
UPDATE statements causing me grief!
Greetings, been a DBI user for years now working with stuff from
unixODBC, Oracle, MySQL, etc
Some time, even committed, the data was still mysteriously disappearing while
another tool worked perfectly.
Why??
I was playing on different databases!
I know it sounds silly but did you forget to commit? I've been
doing DB programming for years but every now and again I waste
On Oct 7, 2011, at 7:25 AM, tiger peng wrote:
Some time, even committed, the data was still mysteriously disappearing while
another tool worked perfectly.
Why??
ROFL.
A while back, while I was making changes to a production system, I modified the
authentication scripts so that when I
On Oct 7, 2011, at 11:32 AM, Bruce Johnson wrote:
On Oct 7, 2011, at 7:25 AM, tiger peng wrote:
Some time, even committed, the data was still mysteriously disappearing
while another tool worked perfectly.
Why??
ROFL.
A while back, while I was making changes to a production
10 matches
Mail list logo