<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 <fabi...@techno7.com.br>:

> Show your code
>
>
> 2014-06-06 15:18 GMT-03:00 LoveWeb2py <atayloru...@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 <fabi...@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+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 a topic in the
>>>> Google Groups "web2py-users" group.
>>>> To unsubscribe from this topic, visit https://groups.google.com/d/
>>>> topic/web2py/I8aGvbVcQxk/unsubscribe.
>>>> To unsubscribe from this group and all its topics, 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.
>>
>
>

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

Reply via email to