Re: [Boston.pm] Class::DBI sporadic errors

On Wed, Oct 19, 2005 at 01:04:40PM -0400, Uri Guttman wrote:
> >>>>> "DB" == Dan Boger <dan-rlx3YLNxYWXQT0dZR+AlfA@xxxxxxxxxxxxxxxx> writes:
>   DB>   my @res = Peeron2::Sets->search_where(ID => $setid);
> 
> from the class::dbi docs:
> 
>   my @music = Music::CD->search_where(
>     artist => [ 'Ozzy', 'Kelly' ],
>     status => { '!=', 'outdated' },
>   );
> 
> and it says that is further documented in Class::DBI::AbstractSearch
> which in turn is based upon SQL::Abstract.
> 
> it seems to require a hash or array ref as the value for ID. is $setid
> a scalar or a ref? the error seems to corroborate that it needs at
> least an array ref (if it takes a hash ref too, then the error is
> poorly worded as it should say not an ARRAY or HASH ref).

Those are only the advanced cases.  The simple case does accept a
scalar...  I don't remember where I read it (can't seem to find it), but
here's empirical evidence:

qs546$ perl -MPeeron2::Sets -MData::Dumper -le '
@res = Peeron2::Sets->search_where(ID => "8880-1");
print Dumper $res[0]'
$VAR1 = bless( {
                 'inventory' => 'Yes',
                 'instructions' => bless( {
                                            'instid' => '1952'
                                          }, 'Peeron2::Instructions' ),
                 'name' => 'Super Car',
                 'msrp' => '130.00',
                 'figs' => '0',
                 'setrev' => '1',
                 'setnumber' => '8880',
                 'pcs' => '1343',
                 'id' => '8880-1',
                 'picture' => bless( {
                                       'id' => '1409'
                                     }, 'Peeron2::SetPic' ),
                 'year' => '1994',
                 'theme' => bless( {
                                     'id' => '12'
                                   }, 'Peeron2::Theme' )
               }, 'Peeron2::Sets' );


-- 
Dan Boger
dan-rlx3YLNxYWXQT0dZR+AlfA@xxxxxxxxxxxxxxxx