Yes there are, it's called the 'trim' function. It's part of SQL-92. http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt
Postgres, MSSQL, MySQL, SQLite, and Oracle all have rtrim, and ltrim. I think it's widely supported and thus we should support it in DAL. It's easy enough to write a function that handles it if the database driver doesn't support it. On Friday, May 29, 2015 at 5:54:46 AM UTC-7, Niphlod wrote: > > 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.
