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 [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
-~----------~----~----~----~------~----~------~--~---
