Try this:
db(db.person.id0).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.id0).update(name = db.person.name + x)
This does not:
Whoops, backwards:
db(db.person.id0).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.id0).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
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.id0).update(name = %s%s % (x,db.person.name))
On
A bigger problem...
On further testing, it looks like db(db.person.id0).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
This is ugly but should work:
from gluon.sql import Expression
db(db.person.id0).update(name = Expression('person.name || x'))
I'm almost positive there is a better way.
On Mar 24, 10:43 pm, Russell russell.mcmur...@gmail.com wrote:
A bigger problem...
On further testing, it looks like
hrm...
for row in db(db.person.id 0).select():
row.update_record(name = row.name + x)
This also will work, although not as efficient since the processing
will be done in python and not the database.
-Thadeus
On Wed, Mar 24, 2010 at 11:10 PM, mr.freeze nat...@freezable.com wrote:
This
Thanks both of you for your replies. I've been trying to avoid doing
it in python (lots of records) so I think I'll try mr.freeze's
solution.
On Mar 25, 5:18 pm, Thadeus Burgess thade...@thadeusb.com wrote:
hrm...
for row in db(db.person.id 0).select():
row.update_record(name = row.name
7 matches
Mail list logo