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.

Reply via email to