Anything present in admin/reports/dblog? The theme function itself can return an empty string. The theme_pager function though, if called, doesn't give an empty string. You must use the setQueryCount() method to limit the query, also if one page or less of data is displayed no pager is output for it either.<br>
<br><div class="gmail_quote">On Mon, Oct 29, 2012 at 2:20 PM, Ms. Nancy Wichmann <span dir="ltr"><<a href="mailto:nan_wich@bellsouth.net" target="_blank">nan_wich@bellsouth.net</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:12pt;font-family:arial,helvetica,sans-serif"><div><span>I am not creating a form, so I have</span></div><div style="font-style:normal;font-size:16px;background-color:transparent;font-family:arial,helvetica,sans-serif">
<span><span style="font-family:Courier New,courier,monaco,monospace,sans-serif"> $output .= theme('table', $table);<br> $output .= theme('pager');<br></span>The table displays just fine. I have dumped the output of the pager function and it is NULL.<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:arial,helvetica,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"> <hr size="1"> <b><span style="font-weight:bold">From:</span></b> Earnie Boyd <<a href="mailto:earnie@users.sourceforge.net" target="_blank">earnie@users.sourceforge.net</a>><br>
<b><span style="font-weight:bold">To:</span></b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a>; Ms. Nancy Wichmann <<a href="mailto:nan_wich@bellsouth.net" target="_blank">nan_wich@bellsouth.net</a>> <br>
<b><span style="font-weight:bold">Sent:</span></b> Monday, October 29, 2012 1:55 PM<br> <b><span style="font-weight:bold">Subject:</span></b> Re: [support] Pager Query D7<br> </font> </div> <br>
<div>Do you have something similar to<div><br></div><div>$form['pager'] = array('#value' => theme('pager'))</div><div><br></div><div>You may also need $query->setQueryCount() instead of the addExpression <a href="http://api.drupal.org/api/drupal/includes%21pager.inc/function/PagerDefault%3A%3AsetCountQuery/7" target="_blank">http://api.drupal.org/api/drupal/includes%21pager.inc/function/PagerDefault%3A%3AsetCountQuery/7</a></div>
<div><br><br><div>On Mon, Oct 29, 2012 at 12:20 PM, Ms. Nancy Wichmann <span dir="ltr"><<a rel="nofollow" href="mailto:nan_wich@bellsouth.net" target="_blank">nan_wich@bellsouth.net</a>></span> wrote:<br><blockquote style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div style="font-size:12pt;font-family:Courier New,courier,monaco,monospace,sans-serif"><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 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"> <hr size="1"> <b><span style="font-weight:bold">From:</span></b> Jamie Holly <<a rel="nofollow" href="mailto:hovercrafter@earthlink.net" target="_blank">hovercrafter@earthlink.net</a>><br>
<b><span style="font-weight:bold">To:</span></b>
<a rel="nofollow" href="mailto:support@drupal.org" target="_blank">support@drupal.org</a> <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>
<div>
<div>When using extenders, the position of
the extender is important. Check out:<br>
<br>
<a href="http://drupal.org/node/508796" target="_blank">http://drupal.org/node/508796</a><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>Jamie Holly
<a href="http://www.intoxination.net" target="_blank">http://www.intoxination.net</a>
<a href="http://www.hollyit.net" target="_blank">http://www.hollyit.net</a></pre>
On 10/29/2012 11:49 AM, Ms. Nancy Wichmann wrote:<br>
</div>
<blockquote type="cite">
<div style="font-size:12pt;font-family:tahoma,new york,times,serif">
<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></fieldset>
<br>
</blockquote>
<br><span><font color="#888888">
</font></span></div><span><font color="#888888">
</font></span></div><span><font color="#888888"><br>-- <br>[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br><br><span class="HOEnZb"><font color="#888888"> </font></span></font></span></div>
<span class="HOEnZb"><font color="#888888"> </font></span></div><span class="HOEnZb"><font color="#888888"> </font></span></blockquote><span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888"> </font></span></div></div><span class="HOEnZb"><font color="#888888"><br>--<br>
[ Drupal support list | <a rel="nofollow" href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></font></span></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all">
<div><br></div>-- <br><div>Earnie</div><div>-- <a rel="nofollow" href="https://sites.google.com/site/earnieboyd" target="_blank">https://sites.google.com/site/earnieboyd</a></div>
<br>
</font></span></div><span class="HOEnZb"><font color="#888888">
</font></span></div><span class="HOEnZb"><font color="#888888"><br><br> </font></span></div> </div> </blockquote></div> </div></div></blockquote></div><br><br clear="all"><div><br></div>-- <br><div>Earnie</div><div>-- <a href="https://sites.google.com/site/earnieboyd" target="_blank">https://sites.google.com/site/earnieboyd</a></div>
<br>