These are different problems. Even you could do "as", which you technically an but it is complicated, would not rename the web2py column.
You can rename the column without the "as". rows=db(..).select(...) rows.colnames is a list with the colnames. You can change any element in this list as you please. Look what is in there first. Massimo On Jun 19, 3:27 am, "Sebastian E. Ovide" <sebastianov...@gmail.com> wrote: > I'm looking for a way to use "AS" in a query so that I can rename columns... > > so for example: > > rows=db().select(db.mytable.date,db.mytable.clicks.sum(),db.mytable.impressions.sum(),groupby=db.mytable.date) > > produces > > SELECT mytable.date, SUM(mytable.clicks), SUM(mytable.impressions) FROM > mytable GROUP BY mytable.date; > > and so I can do > > print rows[1].date > > but I need to rename the columns... > > for example rename SUM(mytable.impressions) as impressions so that I can do > > print rows[1].impressions > > is there any way to do it without using db.executesql ? > > On Fri, Jun 19, 2009 at 11:26 AM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > yes and no. You can do: > > > morehits = db.mytable.myhits.sum() > > rows=db().select(db.mytable.mydate,morehits,groupby=db.mytable.mydate) > > for row in rows: > > print row.mytable.mydate, row._extra[morehits] > > > but the morehits does not appear in the actual generated SQL because > > there is no need to. > > > On Jun 18, 2:15 pm, sebastian <sebastianov...@gmail.com> wrote: > > > Hi, > > > > is it possible to run this select using DAL ? > > > > select date,sum(hits) as morehits from report group by date > > > > (see the "as") > > > > 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 web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
