there are no functions in T-SQL accross backends that do what you ask, so
you'll need to do it in python
for rec in db(db.table.id >0).select():
rec.update_record(field=rec.field.strip())
On Friday, May 29, 2015 at 6:33:28 AM UTC+2, Jerry Liu wrote:
>
> Hello, all
>
> I want to update all of records of a table. Basically, what I want to
> update is just a string Field. I want to strip all spaces out of that Field.
>
> I have tried:
>
> db(db.table.id > 0).update(field = db.table.field.strip())
>
> But looks like Field object doesn't have a strip method.
>
> Any ideas?
>
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
