When using extenders, the position of the extender is important. Check out:

http://drupal.org/node/508796

So make sure you have the ->extend right after your select. Then use your $query to do whatever other joins, conditions, fields, etc. you want. Put the limit in on that too.

You might want to check out node_admin_nodes() in node.admin.inc to get a better idea.
Jamie Holly
http://www.intoxination.net 
http://www.hollyit.net
On 10/29/2012 11:49 AM, Ms. Nancy Wichmann wrote:
I have a pager query ("$query = $query->extend('PagerDefault')->limit($limit);") coded and it is working fine. However, the theme('pager') is doing nothing. It returns a null string, so I am not getting a pager on the page. I have searched all over D.O, but am apparently missing the solution.
 
Nancy
 
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.