-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
 
 
Brendan LeFebvre writes:
 
> Even more perplexing: the "0E0" occurs ONLY when setting status to
> 'STORE', and not 100% of the time. (though it happens far more often
> than not.) It seems to operate in stretches, too: when I am getting
> 1-row updates back from the latter query type, it happens several
> times in succession.
 
"0E0" is perl's way of saying "0 but true", which means that the
statement succeeded, but did not return any rows. If it simply
returned a "0", we would not be able to differentiate between
an error (false) and no rows affected (0).
 
> Where do I even begin to attempt a diagnosis?
 
It looks as thogh the row you are trying to update does not
exist. Not much more advice is possible without seeing a more
complete sample of the code.
 
"boyd" writes:
 
> $info =~ s/0//g; # the get_info adds extraneous '0' to the version number
 
It is not extraneous: it is required per the ODBC spec. For a simpler
number, try using this:
 
my $pgversion = $dbh->{private_dbdpg}{server_version};
 
 
- --
Greg Sabino Mullane [EMAIL PROTECTED]
PGP Key: 0x14964AC8 200401111401
 
-----BEGIN PGP SIGNATURE-----
 
iD8DBQFAAaEwvJuQZxSWSsgRAk59AJ4zeNNm225TdecB2wgcQnFIJNqpmgCePmdX
XAPC7vVv+517CR2g3p/6U6c=
=oSYK
-----END PGP SIGNATURE-----



---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to