This is perfect, thanks. Meant it wouldnt run, and the values were NULL. On Tuesday, January 21, 2014 11:25:39 AM UTC-5, Anthony wrote: > > What do you mean it won't run? Do you get an error, or just don't see the > changes you expect? Are the values in question in the database actually > None (i.e., NULL), or are they empty strings ('')? > > If you're trying to change all the records in the table, would be easier > to do: > > for field in ['name', 'address']: > db(db.mytable[field] == None).update(**{field: 'Not Specified'}) > > That will just issue two updates rather selecting the entire table and > then doing two updates per row. > > Also, if you have a Rows object and need to make multiple changes to a > given Row, you can do: > > row.update(...) > row.update(...) > row.update_record() > > The row.update() calls make changes to the Row object itself (but not the > database). Then, .update_record() updates the database with whatever > changes have been made to the Row. > > Anthony > > On Tuesday, January 21, 2014 11:00:10 AM UTC-5, Mark Billion wrote: >> >> I cannot seem to get this code to run, even though Im almost sure Im >> right.....any thoughts would be appreciated! >> >> for r in rows: >> >> . . . . . >> >> for k, v in {'name': r.name, 'address': r.address . . . }.items(): >> if v is None: >> db(db.client.id==r.id).update(**{k:'Not Specified'}) >> >>
-- 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/groups/opt_out.