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
-~----------~----~----~----~------~----~------~--~---
