> 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)

> On Sat, Nov 7, 2009 at 7:22 AM, geekbuntu <gmi...@gmail.com> 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
> ang...@gladding.name
> http://angelo.gladding.name/
> E69E 47E8 5C3A 96E5 C70F
> D931 F35C ACBA 6F39 9611

> On Sat, Nov 7, 2009 at 7:22 AM, geekbuntu <gmi...@gmail.com> 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
> ang...@gladding.name
> http://angelo.gladding.name/
> E69E 47E8 5C3A 96E5 C70F
> D931 F35C ACBA 6F39 9611

> On Sat, Nov 7, 2009 at 7:22 AM, geekbuntu <gmi...@gmail.com> 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
> ang...@gladding.name
> http://angelo.gladding.name/
> E69E 47E8 5C3A 96E5 C70F
> D931 F35C ACBA 6F39 9611

> On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name>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 <gmi...@gmail.com> 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
>> ang...@gladding.name
>> http://angelo.gladding.name/
>> E69E 47E8 5C3A 96E5 C70F
>> D931 F35C ACBA 6F39 9611

> 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 <gmi...@gmail.com> wrote:

>> actually i was trying to learn how to paginate in webpy.

>> On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name>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 <gmi...@gmail.com> 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
>>> ang...@gladding.name
>>> http://angelo.gladding.name/
>>> E69E 47E8 5C3A 96E5 C70F
>>> D931 F35C ACBA 6F39 9611

> On Sat, Nov 7, 2009 at 5:28 PM, Leon Waldman <le.wald...@gmail.com>  
> 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 <gmi...@gmail.com> wrote:
> actually i was trying to learn how to paginate in webpy.

> On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding  
> <ang...@gladding.name> 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 <gmi...@gmail.com> 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
> ang...@gladding.name
> http://angelo.gladding.name/
> E69E 47E8 5C3A 96E5 C70F
> D931 F35C ACBA 6F39 9611

> On Nov 7, 2009, at Nov 7, 2009 - 7:56 PM, Greg Milby wrote:

> what is afaik?

> On Sat, Nov 7, 2009 at 5:28 PM, Leon Waldman <le.wald...@gmail.com> 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 <gmi...@gmail.com> wrote:

>>> actually i was trying to learn how to paginate in webpy.

>>> On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name>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 <gmi...@gmail.com> 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
>>>> ang...@gladding.name
>>>> http://angelo.gladding.name/
>>>> E69E 47E8 5C3A 96E5 C70F
>>>> D931 F35C ACBA 6F39 9611

> On Sat, Nov 7, 2009 at 7:58 PM, alexander lind <a...@polkabrothers.com>wrote:

>> as far as i know.

>> On Nov 7, 2009, at Nov 7, 2009 - 7:56 PM, Greg Milby wrote:

>> what is afaik?

>> On Sat, Nov 7, 2009 at 5:28 PM, Leon Waldman <le.wald...@gmail.com>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 <gmi...@gmail.com> wrote:

>>>> actually i was trying to learn how to paginate in webpy.

>>>> On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name>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 <gmi...@gmail.com> 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
>>>>> ang...@gladding.name
>>>>> http://angelo.gladding.name/
>>>>> E69E 47E8 5C3A 96E5 C70F
>>>>> D931 F35C ACBA 6F39 9611

> paths = ('/books', 'Books')
> app = web.application(paths, globals())

> class Books:
>   def GET(self):
>     """
>     >>> assert app.request('/books?p=4').status == '200 OK'

>     """
>     try:
>       offset = web.input('p').p * 10
>     except web.badrequest:
>       return list(db.select('books', order='title'))
>     return list(db.select('books', order='title', offset=offset, limit=10))

> Let me know if that helps.

> 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 <gmi...@gmail.com> wrote:

> > actually i was trying to learn how to paginate in webpy.

> > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name>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 <gmi...@gmail.com> 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
> >> ang...@gladding.name
> >> http://angelo.gladding.name/
> >> E69E 47E8 5C3A 96E5 C70F
> >> D931 F35C ACBA 6F39 9611

> SELECT * FROM `books` ORDER BY `title` ASC LIMIT 0, 10
> SELECT * FROM `books` ORDER BY `title` ASC LIMIT 10, 20

> Using web.db:

> db.select('books', order='title', offset=0, limit=10)
> db.select('books', order='title', offset=10, limit=20)

> see http://webpy.org/cookbook/select

> Try something like this:

> paths = ('/books', 'Books')
> app = web.application(paths, globals())

> class Books:
>   def GET(self):
>     """
>     >>> assert app.request('/books?p=4').status == '200 OK'

>     """
>     try:
>       offset = web.input('p').p * 10
>     except web.badrequest:
>       return list(db.select('books', order='title'))
>     return list(db.select('books', order='title', offset=offset, limit=10))

> Let me know if that helps.

> On Sat, Nov 7, 2009 at 6:02 PM, Greg Milby <gmi...@gmail.com> wrote:

>> ah - ty

>> On Sat, Nov 7, 2009 at 7:58 PM, alexander lind <a...@polkabrothers.com>wrote:

>>> as far as i know.

>>> On Nov 7, 2009, at Nov 7, 2009 - 7:56 PM, Greg Milby wrote:

>>> what is afaik?

>>> On Sat, Nov 7, 2009 at 5:28 PM, Leon Waldman <le.wald...@gmail.com>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 <gmi...@gmail.com> wrote:

>>>>> actually i was trying to learn how to paginate in webpy.

>>>>> On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name>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 <gmi...@gmail.com> 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
>>>>>> ang...@gladding.name
>>>>>> http://angelo.gladding.name/
>>>>>> E69E 47E8 5C3A 96E5 C70F
>>>>>> D931 F35C ACBA 6F39 9611

> --
> Angelo Gladding
> ang...@gladding.name
> http://angelo.gladding.name/
> E69E 47E8 5C3A 96E5 C70F
> D931 F35C ACBA 6F39 9611

> > Try something like this:

> > paths = ('/books', 'Books')
> > app = web.application(paths, globals())

> > class Books:
> >   def GET(self):
> >     """
> >     >>> assert app.request('/books?p=4').status == '200 OK'

> >     """
> >     try:
> >       offset = web.input('p').p * 10
> >     except web.badrequest:
> >       return list(db.select('books', order='title'))
> >     return list(db.select('books', order='title', offset=offset,
> limit=10))

> > Let me know if that helps.

> Small correction.

> web.input('p').p returns a string. It must be converted to int before
> multiplying with 10.
> Also p must be optional parameter.

> try:
>    p = int(web.input(p=0).p)
> except ValueError:
>    p = 0

> offset = p*10

> 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 <gmi...@gmail.com> wrote:

> > > actually i was trying to learn how to paginate in webpy.

> > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name
> >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 <gmi...@gmail.com> 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
> > >> ang...@gladding.name
> > >> http://angelo.gladding.name/
> > >> E69E 47E8 5C3A 96E5 C70F
> > >> D931 F35C ACBA 6F39 9611

> On Sat, Nov 7, 2009 at 10:58 PM, Justin Caratzas
> <justin.carat...@gmail.com>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 <gmi...@gmail.com> wrote:

> > > > actually i was trying to learn how to paginate in webpy.

> > > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name
> > >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 <gmi...@gmail.com> 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
> > > >> ang...@gladding.name
> > > >> http://angelo.gladding.name/
> > > >> E69E 47E8 5C3A 96E5 C70F
> > > >> D931 F35C ACBA 6F39 9611

> I'm assuming you got that problem fixed, because I just checked that link
> and it seems to work fine.  The last 8 pages or so have data.

> Justin

> ps.  Is this for the Book Nook franchise of used book stores?  I love that
> place.

> On Sun, Nov 08, 2009 at 06:19:53AM -0500, Greg Milby 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
> > <justin.carat...@gmail.com>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 <gmi...@gmail.com>
> wrote:

> > > > > actually i was trying to learn how to paginate in webpy.

> > > > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <
> ang...@gladding.name
> > > >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 <gmi...@gmail.com>
> 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
> > > > >> ang...@gladding.name
> > > > >> http://angelo.gladding.name/
> > > > >> E69E 47E8 5C3A 96E5 C70F
> > > > >> D931 F35C ACBA 6F39 9611

> On Sun, Nov 8, 2009 at 2:19 PM, Justin Caratzas <justin.carat...@gmail.com
> > wrote:

>> I'm assuming you got that problem fixed, because I just checked that link
>> and it seems to work fine.  The last 8 pages or so have data.

>> Justin

>> ps.  Is this for the Book Nook franchise of used book stores?  I love that
>> place.

>> On Sun, Nov 08, 2009 at 06:19:53AM -0500, Greg Milby 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
>> > <justin.carat...@gmail.com>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 <gmi...@gmail.com>
>> wrote:

>> > > > > actually i was trying to learn how to paginate in webpy.

>> > > > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <
>> ang...@gladding.name
>> > > >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 <gmi...@gmail.com>
>> 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
>> > > > >> ang...@gladding.name
>> > > > >> http://angelo.gladding.name/
>> > > > >> E69E 47E8 5C3A 96E5 C70F
>> > > > >> D931 F35C ACBA 6F39 9611

> On Sun, Nov 8, 2009 at 9:32 AM, Greg Milby <gmi...@gmail.com> wrote:

>> yes, i actually discovered what was wrong on the jquery pagination.  i may
>> run with that since it would reduce the load on the webserver. thank you

>> On Sun, Nov 8, 2009 at 2:19 PM, Justin Caratzas <
>> justin.carat...@gmail.com> wrote:

>>> I'm assuming you got that problem fixed, because I just checked that link
>>> and it seems to work fine.  The last 8 pages or so have data.

>>> Justin

>>> ps.  Is this for the Book Nook franchise of used book stores?  I love
>>> that place.

>>> On Sun, Nov 08, 2009 at 06:19:53AM -0500, Greg Milby 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
>>> > <justin.carat...@gmail.com>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 <gmi...@gmail.com>
>>> wrote:

>>> > > > > actually i was trying to learn how to paginate in webpy.

>>> > > > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <
>>> ang...@gladding.name
>>> > > >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 <gmi...@gmail.com>
>>> 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
>>> > > > >> ang...@gladding.name
>>> > > > >> http://angelo.gladding.name/
>>> > > > >> E69E 47E8 5C3A 96E5 C70F
>>> > > > >> D931 F35C ACBA 6F39 9611

> --
> Angelo Gladding
> ang...@gladding.name
> http://angelo.gladding.name/
> E69E 47E8 5C3A 96E5 C70F
> D931 F35C ACBA 6F39 9611

> On Sat, Nov 7, 2009 at 10:58 PM, Justin Caratzas <
> justin.carat...@gmail.com> 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 <gmi...@gmail.com> wrote:

>> > > actually i was trying to learn how to paginate in webpy.

>> > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name
>> >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 <gmi...@gmail.com> 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
>> > >> ang...@gladding.name
>> > >> http://angelo.gladding.name/
>> > >> E69E 47E8 5C3A 96E5 C70F
>> > >> D931 F35C ACBA 6F39 9611

>  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 <gmi...@gmail.com> 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 <
> > justin.carat...@gmail.com> 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 <gmi...@gmail.com> wrote:

> >> > > actually i was trying to learn how to paginate in webpy.

> >> > > On Sat, Nov 7, 2009 at 2:09 PM, Angelo Gladding <ang...@gladding.name
> >> >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 <gmi...@gmail.com> 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
> >> > >> ang...@gladding.name
> >> > >> http://angelo.gladding.name/
> >> > >> E69E 47E8 5C3A 96E5 C70F
> >> > >> D931 F35C ACBA 6F39 9611