$query = db_select('comment', 'c')->extend('PagerDefault')->limit($limit)->extend('TableSort');
$query->innerJoin('users', 'u', 'u.uid = c.uid');
$query->addField('u', 'name');
$query->addField('u', 'uid');
$query->addExpression('COUNT(*)', 'number');
$query->groupBy('c.uid');
$query->range(0, $limit);
$query->orderByHeader($table['header']);
$result = $query->execute();
I did look at node_admin_nodes() and don't see anything significant to tell me why theme_pager() isn't working for me.
Nancy
Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.
From: Jamie Holly <hovercrafter@earthlink.net>
To: support@drupal.org
Sent: Monday, October 29, 2012 12:01 PM
Subject: Re: [support] Pager Query D7
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.netOn 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.
--
[ Drupal support list | http://lists.drupal.org/ ]