Hi, I'm in a verry simple situation here with web2py
estados=db(db.tickets.estado==db.estados.id).select('count
(tickets.estado) AS counter', db.estados.nombre,
groupby=db.estados.nombre)
I'm trying to get the column name counter using the AS keyword query,
the query works perfect but I got:
"count(tickets.estado) AS counter", as the COLUMN name, and I need to
get "counter".
Is there any change I could get/use the "AS" keyword ? I'm using
Mysql and It works perfect on mysql prompt.
Thanks in advance, and I'm sorry for my bad english.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
