the query is getting this error:
<type 'exceptions.SyntaxError'> at / ('invalid syntax',
('/media/ST250x01/BACKUP/webpy/myapp.py', 24, 43, " showbooks =
db.select('books' order='title', offset=10, limit=20)\n"))
here's how i'm using it:
16 class index:
17 def GET(self):
18 welcome = 'Welcome'
19 return render.index(welcome)
20
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 Sat, Nov 7, 2009 at 10:24 PM, Angelo Gladding <[email protected]>wrote:
> As raw SQL:
>
> 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 <[email protected]> wrote:
>
>> ah - ty
>>
>>
>> On Sat, Nov 7, 2009 at 7:58 PM, alexander lind <[email protected]>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 <[email protected]>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
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>
>
> --
> 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
-~----------~----~----~----~------~----~------~--~---
