Works great Jim, Thank you very much.
On Tuesday, May 27, 2014 12:52:33 PM UTC-4, Jim S wrote:
>
> I would try something like this:
>
> rows_per_page = 20 # this should be set to whatever the 'paginate'
> parm is set to on your call to SQLFORM.grid - default is 20
> page_number = int(query).count() / rows_per_page ) + 1 # 'query'
> should be the same query that you pass to SQLFORM.grid
>
> redirect(URL('voltrin_data',vars={'page':page_number),user_signature=True)
>
> NOT TESTED!!
>
> Let me know if this doesn't work and I'll code up a test of my own to see
> what happens.
>
> Anyone have a more efficient way of doing this?
>
> -Jim
>
>
>
> On Tuesday, May 27, 2014 11:32:28 AM UTC-5, Tom Russell wrote:
>>
>> Jim,
>>
>> Yes I have a grid page in place which is where I go now. The grid though
>> has a lot of records and I just want to go to that last record in that
>> grid. Since its pagination thats what I am looking for, is how to go to the
>> last page in the grid.
>>
>> On Tuesday, May 27, 2014 12:17:02 PM UTC-4, Jim S wrote:
>>>
>>> When you say that you want to go to the 'grid' page, do you mean a page
>>> with a SQLFORM.grid on it and you want to go into 'edit' mode on a specific
>>> record on the grid?
>>>
>>> -Jim
>>>
>>>
>>> On Tuesday, May 27, 2014 10:42:31 AM UTC-5, Tom Russell wrote:
>>>>
>>>> I have a simple form where I have a submit button that runs some code.
>>>> After the code runs and the data is inserted into my table I do a simple
>>>> redirect like so:
>>>>
>>>> redirect(URL('voltrin_data'))
>>>>
>>>> That just goes to a page I have set up with a grid. I notice if I am
>>>> editing a record and press submit the next page that gets redirected to is
>>>> the last record in the grid.
>>>>
>>>> What I want to do is redirect to my grid but go to the page with the
>>>> l;ast entry and not the first page.
>>>>
>>>> How would I do that? I looked in the book but could not see how I would
>>>> do this.
>>>>
>>>> Thanks,
>>>>
>>>> Tom
>>>>
>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
