Your work-around works well Anthony. Thanks.
What I intend of doing is querying just a subset of a list:string
field (e.g. mytblalias.data[0:6] which in select would appear as:
SUBSTR(mytblalias.data,1,(7 - 1))
The field results, however, turned out to be raw with the '|' showing
as separators instead of a list but I could process that before
passing it to a function as the fields final destination.
Noel
On Sep 9, 8:18 am, Anthony <abasta...@gmail.com> wrote:
> You can select db.mytbl.id*2, but I don't think you can reference the result
> with an alias -- you'd have to reference it with something like
> rows[0]['(mytbl.id
> * 2)']. Of course, for convenience, you could define fld2='(mytbl.id * 2)' and
> then do rows[0][fld2].
>
> What do you want to do with the results?
>
> Anthony
>
>
>
>
>
>
>
> On Thursday, September 8, 2011 3:07:55 AM UTC-4, Noel Villamor wrote:
>
> > I am aware about:
> > tblAlias = db.mytbl.with_alias('tblAlias')
>
> > Is there a similar thing that we can use for fields in select()?
> > As in:
> > ... .select( db.mytbl.id, db.mytbl.id*2 as fld2)
