SELECT + SUM

36 views
Skip to first unread message

Geanderson

unread,
May 24, 2012, 3:28:38 PM5/24/12
to web2py-users-brazil
Quero retornar na index o resultado da soma de um campo específico do
banco de dados...qual a melhor forma para o model, controller e view?

SELECT campo A,
SUM (campo B)
FROM (db.name)
WHERE campo A ='mylabel'

crud.select (db.name, field_labels = {'dbcolname':'mylabel}
Reply all
Reply to author
Forward
0 new messages