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 <[email protected]
> <javascript:>>:
>
>> Show your code
>>
>>
>> 2014-06-06 15:18 GMT-03:00 LoveWeb2py <[email protected] <javascript:>>:
>>
>> 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 <[email protected]
>>>> <javascript:>> 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 <[email protected]>:
>>>>>>>>>
>>>>>>>>>> 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 [email protected].
>>>>>>>>>> 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 [email protected] <javascript:>.
>>>>>>
>>>>>> 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
>>>>> [email protected] <javascript:>.
>>>>> 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 [email protected] <javascript:>.
>>> 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 [email protected].
For more options, visit https://groups.google.com/d/optout.
