Re: [SQLObject] Trying to use HAVING clause

2008-01-24 Thread Richard Jones
On Friday 25 January 2008 08:01:13 Richard Jones wrote: > Thanks for your explanation, now how do I get a connection? :) > > I'm using TurboGears (for the first time). I guess I need to sign up to a > TG mailing list now... FWIW the magic is: from turbogears import database database.Package

Re: [SQLObject] Trying to use HAVING clause

2008-01-24 Thread Petr Jakeš
> > Thanks for your explanation, now how do I get a connection? :) > > I'm using TurboGears (for the first time). I guess I need to sign up to a > TG > mailing list now... > Hi, in my case, I am doing following: === snip if os.name == 'posix': db_filename = '/opt/f

Re: [SQLObject] Trying to use HAVING clause

2008-01-24 Thread Oleg Broytmann
On Fri, Jan 25, 2008 at 08:01:13AM +1100, Richard Jones wrote: > On Fri, 25 Jan 2008, Oleg Broytmann wrote: > > On Thu, Jan 24, 2008 at 07:17:55PM +1100, Richard Jones wrote: > >After you have created an instance of the Select class you need to > > render it to an SQL query, run the query and g

Re: [SQLObject] Trying to use HAVING clause

2008-01-24 Thread Richard Jones
On Fri, 25 Jan 2008, Oleg Broytmann wrote: > On Thu, Jan 24, 2008 at 07:17:55PM +1100, Richard Jones wrote: > > Feeding the sqlbuilder.Select directly to the > > SQLObject.select() doesn't work, obviously :) > >After you have created an instance of the Select class you need to > render it to an

Re: [SQLObject] Trying to use HAVING clause

2008-01-24 Thread Oleg Broytmann
On Thu, Jan 24, 2008 at 07:17:55PM +1100, Richard Jones wrote: > 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) > > I've searched around and found hints towards the sqlbuil