On 7/21/06 7:55 PM, John Siracusa wrote:
> package myManager;
> sub user_search {
> my ( $class, %args )= @_ ;
> my @ors;
> foreach my $_or ( @{$args{'type_id'}} ) {
> push @or , { 'type_id'=> $_or };
Why is that pushing a hashref onto @or? I think it should just be:
push(@or, type_id => $_or);
> my $results= $class->get_useraccount_findmeon(
> query=> [
> resource=> $args{resource} ,
> is_deleted=> 0,
> where=> [
> 'or'=> [EMAIL PROTECTED]
> ]
Print that whole query => ... value with Data::Dumper and see what it looks
like. (Is "where" a column name?) Also, set
$Rose::DB::Object::Manager::Debug = 1;
to see the SQL the SQL that it's generating.
-John
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object
