Hi Massimo, Sorry, the example did not speak well. I was just trying to do math with string fields which contain numeric values and vice versa, when concatting two numbers by appearance (e.g 123+456 ->123456) so again one example: db().select(tb.tab.stringfield + db.tab.int_field) or db().select(tb.tab.stringfield + db.tab.string2_field)
On Friday, June 20, 2014 5:25:19 AM UTC+7, Massimo Di Pierro wrote: > > an you explain what you are trying to achieve? I am not sure from the > example. > > On Tuesday, 17 June 2014 01:29:11 UTC-5, Pham Quang Dung wrote: >> >> I am using SQLite and it appears no casting is available (or required?). >> But I cannot perform a command like this: >> db().select('test'+ db.tab.int_account) >> >> can you show me the right syntax to make it happen? >> > -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.