Hi,
Sorry for my poor english, by lazy, sometimes I use google translate
(portuguese -> english), and don't check the translation.
table1_inv_record = request.args(0)
In this line you get de first args, but on click to edit record in grid,
the function it's called again and url change args, then first args in url
is 'edit', and this is literal, not numerical.
row = db(db.table1.id==table1_inv_record).select()
In edit mode (and changed url), get error because var table1_inv_record is
not numerical at this time. I think this is a line in your traceback error.
So I use try...except block to convert first arg in integer, if ok, use
session to store de right id sent in the original url.
> alm = None # this is for prevent error case haven't args(0)
> if request.args: alm = request.args(0)
> try:
> if alm:
> alm = int(alm)
> *session.almoxarifado*=alm # this line executes only if the
> previous line no error
> except ValueError:
> pass
> Objeto.almoxarifado_id.default = *session.almoxarifado*
2014-06-09 13:47 GMT-03:00 LoveWeb2py <atayloru...@gmail.com>:
> Hi Fabiano,
>
> Thank you for your reply. What do you mean by *"edit the registry of URL
> arguments are changed. "*
>
> Here is my code:
> def query_table2():
> table2_records = []
> table1_inv_record = request.args(0)
> row = db(db.table1.id==table1_inv_record).select()
> for line in row:
> joined_records = line.inv_id
> query=db.table1.id.belongs(joined_records)
> grid=SQLFORM.grid(query, user_signature=False)
> return dict(grid=grid)
>
> view for query_table2.html:
> {{=grid}}
>
>
>
> On Friday, June 6, 2014 3:43:12 PM UTC-4, Fabiano Almeida wrote:
>
>> <type 'exceptions.ValueError'> invalid literal for int() with base 10:
>> 'edit'
>>
>> In some part of your code has converting string to numeric type. Probably
>> you should be picking up the URL argument and doing the conversion, but
>> when you edit the registry of URL arguments are changed.
>>
>> In my example, I use session and try...except to resolve this.
>>
>>
>>
>> 2014-06-06 15:29 GMT-03:00 Fabiano Almeida <fab...@techno7.com.br>:
>>
>>> Show your code
>>>
>>>
>>> 2014-06-06 15:18 GMT-03:00 LoveWeb2py <atayl...@gmail.com>:
>>>
>>> Now I get this error when I try to click edit on the query database:
>>>>
>>>> <type 'exceptions.ValueError'> invalid literal for int() with base 10:
>>>> 'edit'
>>>>
>>>> I've tried changing signature to false, but I don't think thats the
>>>> problem.
>>>>
>>>>
>>>> On Friday, June 6, 2014 1:17:39 PM UTC-4, LoveWeb2py wrote:
>>>>
>>>>> yes
>>>>>
>>>>>
>>>>> On Fri, Jun 6, 2014 at 1:09 PM, Fabiano Almeida <fab...@techno7.com.br
>>>>> > wrote:
>>>>>
>>>>>> Are you logged in your app?
>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> On Friday, June 6, 2014 1:03:35 PM UTC-4, Fabiano Almeida wrote:
>>>>>>>>
>>>>>>>> Try:
>>>>>>>>
>>>>>>>> grid = SQLFORM.grid(db.table, user_signature=False)
>>>>>>>>
>>>>>>>> Em sexta-feira, 6 de junho de 2014 13h10min34s UTC-3, LoveWeb2py
>>>>>>>> escreveu:
>>>>>>>>>
>>>>>>>>> Hi Fabiano,
>>>>>>>>>
>>>>>>>>> I actually was already using grid= SQLFORM.grid(db.new_table).
>>>>>>>>> That is when I get the error.
>>>>>>>>>
>>>>>>>>> If I do grid='' to test it and just return the table without
>>>>>>>>> SQLFORM I can see it in the view, but when I apply SQLFORM I get the
>>>>>>>>> error
>>>>>>>>> 'Rows' object has no attribute '_db'.
>>>>>>>>>
>>>>>>>>> I'm guessing this is because of the way SQLFORM handles the grid?
>>>>>>>>> Could there be something in my model messing it up?
>>>>>>>>>
>>>>>>>>> On Friday, June 6, 2014 12:02:05 PM UTC-4, Fabiano Almeida wrote:
>>>>>>>>>>
>>>>>>>>>> Hi,
>>>>>>>>>>
>>>>>>>>>> You send var grid (see: return dict(grid=grid)). The first var
>>>>>>>>>> grid is a send var to your view, de second var grid is a local
>>>>>>>>>> var of your function.
>>>>>>>>>>
>>>>>>>>>> Then,
>>>>>>>>>> in controller use:
>>>>>>>>>> grid = SQLFORM.grid(db.new_table)
>>>>>>>>>> return dict(grid=grid)
>>>>>>>>>>
>>>>>>>>>> in the view use:
>>>>>>>>>> {{=grid}}
>>>>>>>>>>
>>>>>>>>>> Fabiano.
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> 2014-06-06 12:45 GMT-03:00 LoveWeb2py <atayl...@gmail.com>:
>>>>>>>>>>
>>>>>>>>>>> SQLFORM isn't working for me with
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> new_table = db(db.table1.id.belongs(record_ids)).select()
>>>>>>>>>>> if I do {{=new_table}} in my view I can see the records which
>>>>>>>>>>> belong to record_ids, but if I do:
>>>>>>>>>>>
>>>>>>>>>>> SQLFORM.grid(new_table)
>>>>>>>>>>> return dict(grid=grid)
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> I get an error 'Rows' object has no attribute '_db'
>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>> 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 web2py+un...@googlegroups.com.
>>>>>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>> 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 web2py+un...@googlegroups.com.
>>>>>>>
>>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>>
>>>>>>
>>>>>> --
>>>>>> 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 a topic in
>>>>>> the Google Groups "web2py-users" group.
>>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to
>>>>>> pic/web2py/I8aGvbVcQxk/unsubscribe.
>>>>>> To unsubscribe from this group and all its topics, send an email to
>>>>>> web2py+un...@googlegroups.com.
>>>>>>
>>>>>> For more options, visit https://groups.google.com/d/optout.
>>>>>>
>>>>>
>>>>> --
>>>> 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 web2py+un...@googlegroups.com.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>>
>> --
> 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 web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
