db.table['fieldname']

четверг, 28 января 2021 г. в 07:31:04 UTC+3, at: 

> It gives error: `*AttributeError('str' object has no attribute 
> 'tablename')*`
>
> The reason is that the field names are in string format not in 
> db.tablename.fieldname format
>
>
> On Wed, Jan 27, 2021 at 6:30 PM Jim Steil <ato....@gmail.com> wrote:
>
>> What is wrong with using the example you provided?
>>
>> -Jim
>>
>>
>> On Tue, Jan 26, 2021 at 10:45 PM Muhammad Atif Ayaz <mati...@gmail.com> 
>> wrote:
>>
>>> Thank you Jim, it works.
>>>
>>> Do you think a way that can help dynamically making a list of all fields 
>>> of a table and then we can remove specific fields from it.
>>> Like the following which produces the required list but in the desired 
>>> data-type: 
>>> fields = [fld for fld in db.engagement.fields if fld!='token']
>>> grid = SQLFORM.grid(db.engagement, fields=fields)
>>>
>>>
>>> On Tue, Jan 26, 2021 at 9:50 PM Jim S <ato....@gmail.com> wrote:
>>>
>>>> Can you try with the field in the format:
>>>>
>>>> db.tablename.fieldname
>>>>
>>>> ex:
>>>>
>>>> fields = [db.engagement.id, db.engagement.name]
>>>>
>>>> -Jim
>>>>
>>>>
>>>> On Monday, January 25, 2021 at 11:45:49 PM UTC-6 at wrote:
>>>>
>>>>> Here is the code:
>>>>> `fields=['id', 'name']`
>>>>> `grid = SQLFORM.grid(db.engagement, fields=fields)`
>>>>>
>>>>> Error:
>>>>> `AttributeError('str' object has no attribute 'tablename')`
>>>>>
>>>>>
>>>>> -- 
>>>> 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/Ym3zsLYNePg/unsubscribe.
>>>> To unsubscribe from this group and all its topics, send an email to 
>>>> web2py+un...@googlegroups.com.
>>>> To view this discussion on the web visit 
>>>> https://groups.google.com/d/msgid/web2py/e19daf19-95c7-4e46-88da-74882bd4e51an%40googlegroups.com
>>>>  
>>>> <https://groups.google.com/d/msgid/web2py/e19daf19-95c7-4e46-88da-74882bd4e51an%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>> .
>>>>
>>> -- 
>>> 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/Ym3zsLYNePg/unsubscribe.
>>> To unsubscribe from this group and all its topics, send an email to 
>>> web2py+un...@googlegroups.com.
>>> To view this discussion on the web visit 
>>> https://groups.google.com/d/msgid/web2py/CAFpY7yFSRZMRPY02sHJtxGasp3T%3Dy7sRdqbq58KncYDdDpkXDg%40mail.gmail.com
>>>  
>>> <https://groups.google.com/d/msgid/web2py/CAFpY7yFSRZMRPY02sHJtxGasp3T%3Dy7sRdqbq58KncYDdDpkXDg%40mail.gmail.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> -- 
>> 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/Ym3zsLYNePg/unsubscribe.
>> To unsubscribe from this group and all its topics, send an email to 
>> web2py+un...@googlegroups.com.
>>
> To view this discussion on the web visit 
>> https://groups.google.com/d/msgid/web2py/CAERBpoCjJrCe_3W1Nq%3DZKh8wFc-e8stoHOpMzDwxMHfbFjexKA%40mail.gmail.com
>>  
>> <https://groups.google.com/d/msgid/web2py/CAERBpoCjJrCe_3W1Nq%3DZKh8wFc-e8stoHOpMzDwxMHfbFjexKA%40mail.gmail.com?utm_medium=email&utm_source=footer>
>> .
>>
>

-- 
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.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/web2py/3b718aef-ec6a-45d3-9c6a-7ae039ae787an%40googlegroups.com.

Reply via email to