On 2/20/06 3:08 PM, Michael Lackhoff wrote: > # but now lets look at it the other way round: > print PVonline::Praxen::Manager->get_praxen_count( > query => [organisation_id => 1] > # same result with this line: > # query => [organisation_id => $id] > ); > # prints 0 !?!
Try adding this before your call to get_praxen_count() local $Rose::DB::Object::Manager::Debug = 1; That'll cause the SQL query to be printed before it's run. If the query still looks correct but gives incorrect results, then please provide a self-contained example of the bug: the database table definitions, some sample data, and the Perl classes. > Another observation, found during debugging attempts: > If I change the query to > query => [non_existant_field => 1] > I get all the sets in this table and not an error about "non existant > field in query" as I expected. Hm, I'll look into that. -John ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642 _______________________________________________ Rose-db-object mailing list Rose-db-object@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/rose-db-object