My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions
Issue 60: empty resultset errors
1 person starred this issue and may be notified of changes. Back to list
Status:  Accepted
Owner:  funnyso...@gmail.com


 
Reported by funnyso...@gmail.com, Dec 16, 2010
my $payee_ids = $dbrh->
  vendor_payee_map->
    where( vendor_id => $params{vendor_id}, status => 'active' )->
      values( 'payee_id' );

this is not clean when resultset is empty.

Use of uninitialized value in concatenation (.) or string at /dj/tools/apollo-utils/lib/ApolloUtils/Logger.pm line 153.
Argument "ROWS: 1" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 0E0" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.

and

my $payee_ids = $vendor->
  mapped_payees->
    where( status => 'active' )->
      values( 'payee_id' );

outputs:

Argument "ROWS: 1" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 0E0" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 0E0" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.

in this case the resultset from the reverse relation is also empty.

Dec 16, 2010
#1 funnyso...@gmail.com
The 0E0 noise appears to be from empty sets.

But there's a lot of noise even when populated with data:

Argument "ROWS: 1" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 2" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 1" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 1" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 2" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 2" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 1" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.
Argument "ROWS: 1" isn't numeric in addition (+) at /usr/lib/perl5/site_perl/5.8.8/DBR/ResultSet.pm line 102.

Be nice if this was silenced.


Powered by Google Project Hosting