Never mind.  It was a bug in my override of the load() method within
Bill::DB::Object::Acct (didn't shift from @_ before calling
$self->SUPER::load(@_).

My bad!  Many apologies!

-- Jeff Horn 

-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeffrey
Horn
Sent: Thursday, May 17, 2007 10:03 PM
To: [EMAIL PROTECTED]; 'Rose::DB::Object list'
Subject: [RDBO] Problem with a Speculative Load

I have a table that has a unique key on (encrypt_ver_num, e_acct_num,
pay_type_id) and a primary key of (acct_id).

The following code: 

#!/usr/bin/perl

use Bill::DB::Object::Acct;
use Data::Dumper;

my $acct = Bill::DB::Object::Acct->new( pay_type_id => 1, e_acct_num =>
'c8923a1e7de803ac73372d64dc11c75c1af2012d90fb6c8d', encrypt_ver_num => 0 );

my $s1=undef;

# This should return 0 from the documentation.
eval {
  $s1 = $acct->load( speculative => 1 ); };

# Bug it doesn't
if ($@) {
  print STDERR "ERROR: [EMAIL PROTECTED]";
}
print STDERR "S1=$s1\n";

Produces: 

ERROR: No such Bill::DB::Object::Acct where encrypt_ver_num, e_acct_num,
pay_type_id = 0, c8923a1e7de803ac73372d64dc11c75c1af2012d90fb6c8d, 1 at
./acct2.pl line 12

S1=

So $acct->load( speculative => 1 ) is actually die-ing.  My understanding is
that "speculative => 1" should force it to return 0.  I'm running on the
latest SVN version of Rose::DB and Rose::DB::Object.  Is this a bug, or am I
not understanding "speculative => 1" correctly?

-- Jeff Horn


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express Download DB2 Express C - the
FREE version of DB2 express and take control of your XML. No limits. Just
data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object


-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to