Oleg Broytmann wrote:
On Mon, May 08, 2006 at 01:03:53PM -0400, Fred C wrote:
I would like to execute a request with a GROUP BY and I understand
that can be done directly with SQLObject and has to be done using
SQLBuilder. But how ?
connection.query(connection.sqrepr(Select("table", ["SUM(price)"],
groupBy="shop")))
Ouch - second parameter is expected to be the where clause, right?
My sepcific problem is:
SELECT COUNT(*) FROM table WHERE MONTH(dateAdded)=5 GROUP BY DAY(dateAdded)
Now, how do you (wrestle to) express that in SQLObject?
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
