[web2py] Re: Bug: Query with Expression that contains comma and space within

[Massimo Di Pierro]

On Sunday, 20 January 2013 14:43:58 UTC-6, Ignacio Ocampo wrote:
>
> When I use custom expression, that contains comma within, it fails if I 
> use an space after comma.
>
> *Example 1*
> --- WORKS ---
> query = ac(tickets.id>0).select(tickets.name, tickets.created_on, 
> "DATEDIFF(tickets.created_*on,N*OW())")
> colnames=['tickets.name', 'tickets.created_on', 
> 'DATEDIFF(tickets.created_o*n,N*OW())']
>
> --- DON'T WORKS ---
> query = ac(tickets.id>0).select(tickets.name, tickets.created_on, 
> "DATEDIFF(tickets.created_*on, N*OW())")
> colnames=['tickets.name', 'tickets.created_on', 
> 'DATEDIFF(tickets.created_on*', '*NOW())']
>
> *Example 2*
> --- WORKS ---
> query = ac(tickets.id>0).select(tickets.name, tickets.created_on, 
> "SUBSTRING(tickets.nam*e,5*)")
> colnames=['tickets.name', 'tickets.created_on', 'SUBSTRING(tickets.nam*e,5
> *)']
> --- DON'T WORKS ---
> query = ac(tickets.id>0).select(tickets.name, tickets.created_on, 
> "SUBSTRING(tickets.nam*e, 5*)")
> colnames=['tickets.name', 'tickets.created_on', 'SUBSTRING(tickets.name*', 
> '*5)']
>
>

--