use a hidden field for the current page number, then set the offset to page *
limit. atleast, thats how i've seen it done before. that could be taken a
step further by ajax.
Justin
On Sun, Nov 08, 2009 at 05:43:15PM -0500, Greg Milby wrote:
> i would still like to know how to paginate in python *if anyone has figured
> it out - even though i will probably use jquery. i do not know where to
> begin with passing the links/code in and out of the template layer...
>
> 21 class books:
> 22 def GET(books):
> 23 db = web.database(dbn='mysql', user='root', pw='', db='books')
> 24 showbooks = db.select('books', order='title', offset=10,
> limit=20)
> 25 return render.books(showbooks)
>
> On Sun, Nov 8, 2009 at 6:19 AM, Greg Milby <[email protected]> wrote:
>
> > i tried that - liked the idea, but it didn't go well.
> > i wrote ascript to make the js (jQuery) data format - but if you look, it
> > displays tons of empty pages at the end, was never able to figure out why -
> > data is formatted to jQuery spec's
> > http://pairadice.no-ip.org/booknook/virt/
> >
> >
> >
> > On Sat, Nov 7, 2009 at 10:58 PM, Justin Caratzas <
> > [email protected]> wrote:
> >
> >>
> >>
> >> or using javascript/JQuery, if you use a standard html table
> >>
> >> Justin Caratzas
> >>
> >> On Sun, Nov 08, 2009 at 12:28:12AM +0200, Leon Waldman wrote:
> >> > Hi,
> >> >
> >> > AFAIK, you can do it on the SQL...
> >> >
> >> > Cheers
> >> >
> >> > --
> >> > Leon Waldman
> >> > SysAdmin Linux - Arquiteto de Infra-Estrutura & TI.
> >> >
> >> >
> >> > On Sat, Nov 7, 2009 at 11:55 PM, Greg Milby <[email protected]> wrote:
> >> >
> >> > > actually i was trying to learn how to paginate in webpy.
> >> > >
> >> > >
> >> > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <[email protected]
> >> >wrote:
> >> > >
> >> > >> Can you clarify what it is you mean by "sort them with links"? Are
> >> you
> >> > >> dealing w/ raw HTML or are you sending an unsorted list to a
> >> template?
> >> > >>
> >> > >>
> >> > >> On Sat, Nov 7, 2009 at 7:22 AM, geekbuntu <[email protected]> wrote:
> >> > >>
> >> > >>>
> >> > >>> i have a wicked long list of used books - wondering if i can sort
> >> them
> >> > >>> with links?
> >> > >>>
> >> > >>> http://pairadice.no-ip.org:8080/books
> >> > >>>
> >> > >>> (around 4500)
> >> > >>>
> >> > >>>
> >> > >>
> >> > >>
> >> > >> --
> >> > >> Angelo Gladding
> >> > >> [email protected]
> >> > >> http://angelo.gladding.name/
> >> > >> E69E 47E8 5C3A 96E5 C70F
> >> > >> D931 F35C ACBA 6F39 9611
> >> > >>
> >> > >>
> >> > >>
> >> > >>
> >> > >
> >> > > >
> >> > >
> >> >
> >> > >
> >>
> >> >>
> >>
> >
>
> >
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web.py" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/webpy?hl=en
-~----------~----~----~----~------~----~------~--~---
