hi mr. freeze,

please go with it, i didn't start doing anything. :)

On 11 Mart, 22:52, "mr.freeze" <[email protected]> wrote:
> Mengu, one made one small change to your code for backwards
> compatibility (putting the value back into _extra).  Other than that,
> I added a with_alias method to Expression so you can do:
>
> rows =
> db(db.stuff.id>0).select(db.stuff.value.count().with_alias('mycount'))
> print rows.first().mycount
>
> I will make patches for sql.py and dal.py that include your code
> unless you have already started.
>
> On Mar 11, 10:16 am, mdipierro <[email protected]> wrote:
>
>
>
> > as is a reserved keyword in Python. We need to use with_alias instead
> > (we do it for Table already). I'd take a patch but this needs to be
> > tested, I am not sure what it may break. Also we need to patch both
> > sql.py and dal.py and they are different.
>
> > Massimo
>
> > On Mar 11, 10:08 am, "mr.freeze" <[email protected]> wrote:
>
> > > I like this too.  Could we go one step further and add an 'as' to
> > > Field class?
>
> > > db.table.field.as('t')
>
> > > On Mar 11, 9:35 am, Thadeus Burgess <[email protected]> wrote:
>
> > > > I like it, much cleaner, and what I would expect.
>
> > > > -Thadeus
>
> > > > On Thu, Mar 11, 2010 at 9:18 AM, Mengu <[email protected]> wrote:
> > > > > Anyone has any other way for writing that query?
>
> > > > > Massimo, wouldn't you accept this as a patch?
>
> > > > > --
> > > > > You received this message because you are subscribed to the Google 
> > > > > Groups "web2py-users" group.
> > > > > To post to this group, send email to [email protected].
> > > > > To unsubscribe from this group, send email to 
> > > > > [email protected].
> > > > > For more options, visit this group 
> > > > > athttp://groups.google.com/group/web2py?hl=en.

-- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/web2py?hl=en.

Reply via email to