You can since 1.49
>>> db=SQLDB()
>>> db.define_table('t',SQLField('a','integer'),SQLField('b','integer'))
>>> db.t.insert(a=2,b=3)
1
>>> db.t.insert(a=3,b=7)
2
>>> shortname=db.t.a.sum()+db.t.b.sum()
>>> rows=db(db.t.id>0).select(shortname)
>>> print rows[0]._extra[shortname]
15
On Nov 26, 7:55 pm, Tari <[EMAIL PROTECTED]> wrote:
> I thought I'd go ahead and ask, and stop googling in vain...
>
> Is there a way to rename a field in a select, e.g. as in
>
> "SELECT SUM(column1) + SUM(column2) AS shortname ..."
>
> Thanks.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
