Try this: db(db.person.id>0).update(name = "%s%s" % (db.person.name,"x"))
On Mar 24, 9:52 pm, Russell <[email protected]> wrote: > Hi there, > > I'm trying to prepend a string to a field. While, this works: > > >>> db(db.person.id>0).update(name = db.person.name + "x") > > This does not: > > >>> db(db.person.id>0).update(name = "x" + db.person.name) > > Traceback (most recent call last): > File "<string>", line 1, in <fragment> > TypeError: cannot concatenate 'str' and 'Expression' objects > > I have found a work-around, but it is pretty ugly: > > >>> db(db.person.id>0).update(name = db.person.name[0:0] + "x" + > >>> db.person.name) > > Does anyone have a better solution? > > Thanks > Russell -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
