Apparently only in one example:
http://web2py.com/books/default/search/29?search=**dict
I can add something about this.
On Friday, 28 December 2012 01:24:37 UTC-6, at wrote:
>
> thank you massimo for this interesting and very useful tip ... it would
> save my good amount of time
> btw, is this syntax available in web2py documentation?
>
> On Friday, 28 December 2012 12:05:46 UTC+5, Massimo Di Pierro wrote:
>>
>> *db((db[table_name].id == rowid) & (db[table_name][myfld] == "")).update(
>> [myfld] = myvalue)*
>> *
>> *
>> *should be*
>> *
>> *
>> *db((db[table_name].id == rowid) & (db[table_name][myfld] ==
>> "")).update(**{myfld:myvalue})*
>> *
>> *
>>
>>
>> On Friday, 28 December 2012 00:40:15 UTC-6, at wrote:
>>>
>>> It's working when I give table_name after getting table object
>>> programatically, but when the same syntax is used for column names in
>>> update statement it returns syntax error; please consider the following
>>> statement:
>>> *db((db[table_name].id == rowid) & (db[table_name][myfld] ==
>>> "")).update([myfld] = myvalue)*
>>>
>>> thanks
>>>
>>> On Thursday, 27 December 2012 19:41:45 UTC+5, Anthony wrote:
>>>>
>>>> *
>>>> db(db[tname].id <http://db.tname.id/> == rowid).select()
>>>>
>>>> *or just:
>>>>
>>>> db[tname](rowid)
>>>>
>>>> Anthony
>>>>
>>>> On Thursday, December 27, 2012 9:35:55 AM UTC-5, at wrote:
>>>>>
>>>>>
>>>>> Wanted to avoid hard-coding table name in the following statement by
>>>>> using var *tname*, but not successful: any tip pls?
>>>>> *db(db.tname.id == rowid).select*
>>>>>
>>>>> Thanks
>>>>>
>>>>> On Thursday, 27 December 2012 19:10:31 UTC+5, at wrote:
>>>>>>
>>>>>> gr8!
>>>>>> *tname,z=my_rows.colnames[0].split('.')* gave the desired table name
>>>>>>
>>>>>> thanks very much!
>>>>>>
>>>>>> best regards
>>>>>>
>>>>>> On Thursday, 27 December 2012 18:47:07 UTC+5, Massimo Di Pierro wrote:
>>>>>>>
>>>>>>> Yes and No. You can get rows.colnames and they contain table names .
>>>>>>> field name
>>>>>>>
>>>>>>> On Thursday, 27 December 2012 07:45:52 UTC-6, at wrote:
>>>>>>>>
>>>>>>>>
>>>>>>>> How can we get table name from ROWS object?
>>>>>>>>
>>>>>>>> Thanks
>>>>>>>>
>>>>>>>
--
