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.
