<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:12pt"><span style="font-family: arial,helvetica,sans-serif;">Thanks, Jamie. No difference.</span><br> $query = db_select('comment', 'c')->extend('PagerDefault')->limit($limit)->extend('TableSort');<br> $query->innerJoin('users', 'u', 'u.uid = c.uid');<br> $query->addField('u', 'name');<br> $query->addField('u', 'uid');<br> $query->addExpression('COUNT(*)', 'number');<br> $query->groupBy('c.uid');<br> $query->range(0, $limit); <br> $query->orderByHeader($table['header']);<br> $result = $query->execute();<br><span style="font-family: arial,helvetica,sans-serif;"> I did look at </span><span style="font-family: arial,helvetica,sans-serif;">node_admin_nodes() and don't see anything significant<span> to tell me why theme_pager()
isn't working for me.</span></span> <img src="http://mail.yimg.com/ok/u/assets/img/emoticons/emo16.gif" alt=":(( crying"><div><span><br></span></div><div> </div><div><font color="#ff007f" face="bookman old style, new york, times, serif" size="4"><i><b>Nancy</b></i></font> <br></div><div><font face="arial, helvetica, sans-serif">Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L. King, Jr.</font></div><div><br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; margin-top: 5px; padding-left: 5px;"> <div style="font-family: Courier New, courier, monaco, monospace, sans-serif; font-size: 12pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font face="Arial" size="2"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Jamie Holly <hovercrafter@earthlink.net><br> <b><span style="font-weight: bold;">To:</span></b>
support@drupal.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Monday, October 29, 2012 12:01 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [support] Pager Query D7<br> </font> </div> <br>
<div id="yiv1993464213">
<div>
<div class="yiv1993464213moz-cite-prefix">When using extenders, the position of
the extender is important. Check out:<br>
<br>
http://drupal.org/node/508796<br>
<br>
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. <br>
<br>
You might want to check out node_admin_nodes() in node.admin.inc
to get a better idea.<br>
<pre class="yiv1993464213moz-signature">Jamie Holly
http://www.intoxination.net
http://www.hollyit.net</pre>
On 10/29/2012 11:49 AM, Ms. Nancy Wichmann wrote:<br>
</div>
<blockquote type="cite">
<div style="color:#000;background-color:#fff;font-family:tahoma, new york, times, serif;font-size:12pt;">
<div><span>I have a pager query ("<span style="
font-family:Courier New, courier, monaco, monospace, sans-serif;">$query =
$query->extend('PagerDefault')->limit($limit);</span>")
coded and it is working fine. However, the <span style="font-family:Courier New, courier, monaco, monospace, sans-serif;">theme('pager')</span>
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.<br>
</span></div>
<div><span></span></div>
<div> </div>
<div><font color="#ff007f" face="bookman old style, new
york, times, serif" size="4"><i><b>Nancy<br>
</b></i></font></div>
<div><font face="arial, helvetica, sans-serif">Injustice
anywhere is a threat to justice everywhere. -- Dr. Martin L.
King, Jr.</font></div>
</div>
<br>
<fieldset class="yiv1993464213mimeAttachmentHeader"></fieldset>
<br>
</blockquote>
<br>
</div>
</div><br>-- <br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br><br> </div> </div> </blockquote></div> </div></body></html>