Re: Problem with has_many and searching

[prev] [thread] [next] [Date index for 2004/10/05]

At 12:21 PM 10/5/2004, Perrin Harkins wrote:
>On Tue, 2004-10-05 at 18:06, John Day wrote:
> > What I want is an iterator pointing to all records in
> > InContact::cDBI::contact which have a matching
> > InContact::cDBI::contactdetail where the value of the recontact field is
> > the selected date - $tm. So I execute this code:
> >
> >      my $details = InContact::cDBI::contact->contact_detail(recontact 
> => $tm);
> >      print Dumper $details;
>
>Does it work without the additional recontact constraint?

Nope
$VAR1 = bless( {
   '_data' => [
     {
       'id' => '1'
     },
     {
       'id' => '2'
     },
     {
       'id' => '4'
     },
     {
       'id' => '5'
     },
     {
       'id' => '6'
     },
     {
       'id' => '7'
     }
   ],
   '_place' => 0,
   '_mapper' => [],
   '_class' => 'InContact::cDBI::contactdetail'
}, 'Class::DBI::Iterator' );

>   Is $tm being
>turned into the right type to search a date field?

Not sure I understand, but I have made my date fields all the same as the 
MySQL. I think if it were not getting the date correct it would not have 
only returned 2 records in the first attempt.

>   Do you have a column
>called contact_detail?

No.

..john


>- Perrin