[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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]


Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
Buy a copy at http://rtbook.bestpractical.com