[rt-users] problems with ticket objects

[Mathew Snyder]

I have the following code:

foreach my $searchDate (@searchDate){
        foreach my $profile (@profiles){
                $ticket = new RT::Tickets(RT::SystemUser);
                $ticket->FromSQL(
                        "(Status = 'open' OR Status = 'resolved') AND
'CF.{Profiles}' = '$profile' AND Created = '$searchDate'"
                );
        }
        while (my $tickobj = $ticket->Next){
                print $tickobj->id;
        }
}

But I"m not getting any results.  Can someone help?

Mathew