[web2py] Re: DAL and Cast operator

2014-06-21 Thread Pham Quang Dung
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

[web2py] Re: DAL and Cast operator

2014-06-19 Thread Massimo Di Pierro
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