try setting echo='debug'. it usually tells all. if any columns in the primary key are NULL, the query won't return an object. If you have partially null primary keys, set allow_null_pks=True on your mapper.
On Mar 17, 2009, at 8:08 PM, Jonathan Vanasco wrote: > > I have query on a view that looks like this: > > query= dbSession.query(_class).filter('entry_status = 2').order_by > ( _class.c.entry_authored_on.desc() ).limit(3).offset(0) > results= query.all() > print query > print " - - - - - -" > print results > print "== == ==" > > this always returns no results. > however the sql query is valid -- and returns results in postgres > > if i remove the limit(3) clause, I get results > > this happens with limiting any number , whether or not I have an > offset, and no matter what the offset is. > > other selects like this on views work absolutely fine. its just on > this one view. its completely puzzling. > > anyone have a clue ? > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---