[support] Pager Query D7

[Earnie Boyd]

Do you have something similar to

$form['pager'] = array('#value' => theme('pager'))

You may also need $query->setQueryCount() instead of the addExpression
http://api.drupal.org/api/drupal/includes%21pager.inc/function/PagerDefault%3A%3AsetCountQuery/7


On Mon, Oct 29, 2012 at 12:20 PM, Ms. Nancy Wichmann <nan_wich at bellsouth.net
> wrote:

> Thanks, Jamie. No difference.
>   $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. [image: :(( crying]
>
>
> *Nancy*
> Injustice anywhere is a threat to justice everywhere. -- Dr. Martin L.
> King, Jr.
>
>   ------------------------------
> *From:* Jamie Holly <hovercrafter at earthlink.net>
> *To:* support at 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 Hollyhttp://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.
>
>
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
>
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>



-- 
Earnie
-- https://sites.google.com/site/earnieboyd
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20121029/7e126fae/attachment.html