I have the following SQL that I'd like to run:
SELECT activated, max(activity) FROM account_status WHERE iccid=?
GROUP BY iccid HAVING activity=max(activity)
against a table:
Name Null? Type
----------------------------------------- -------- ------------
ICCID NOT NULL VARCHAR2(30)
ACTIVATED NOT NULL NUMBER
ACTIVITY NOT NULL DATE
I've searched around and found hints towards the sqlbuilder.Select class, and
have looked for further information about it but found none. I've looked into
the source, but that's not really helped since the "standard"
SQLObject.select() call seems to (eventually) result in SQL being constructed
by something other than the sqlbuilder.Select class (ie. queryForSelect in
dbconnection.py). Feeding the sqlbuilder.Select directly to the
SQLObject.select() doesn't work, obviously :)
Could I please have some additional hints as to how I might get my desired SQL
to execute?
Thanks,
Richard
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
