A bigger problem...
On further testing, it looks like db(db.person.id>0).update(name =
db.person.name + "x") does NOT work.
The DAL seems to treat this as an integer addition and the field is
updated to 0 (at least on sqlite).
On Mar 25, 4:11 pm, Russell <russell.mcmur...@gmail.com> wrote:
> Thanks very much for the reply.
>
> Sorry to say that it doesn't work. Your answer gives this...
> "UPDATE person SET name='xSUBSTR(person.name,1,(1 - 0))';"
>
> On Mar 25, 3:58 pm, "mr.freeze" <nat...@freezable.com> wrote:
>
> > Whoops, backwards:
> > db(db.person.id>0).update(name = "%s%s" % ("x",db.person.name))
>
> > On Mar 24, 9:57 pm, "mr.freeze" <nat...@freezable.com> wrote:
>
> > > Try this:
> > > db(db.person.id>0).update(name = "%s%s" % (db.person.name,"x"))
>
> > > On Mar 24, 9:52 pm, Russell <russell.mcmur...@gmail.com> 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 web...@googlegroups.com.
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
