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