db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Trevor Miller" <web...@fox5.co.za>
Subject Re: Select Where Max
Date Fri, 07 Jul 2006 06:09:54 GMT
Hi,

Thanx, that worked! Amazing how simple it is, I thought I'd have to use a
Criteria.CUSTOM.

Regards,
Trevor


> Hi,
>
> have you tried the following:
>
> Criteria criteria = new Criteria();
> criteria.add(GalleryPeer.VIEWS, "max(" + GalleryPeer.VIEWS + ")");
> List result =GalleryPeer.doSelect(criteria);
>
>
>     Thomas
>
> "Trevor Miller" <web1p3@fox5.co.za> schrieb am 06.07.2006 07:46:13:
>
>> Hi All,
>>
>> I have been scratching my head trying to figure out how to do the
> following:
>>
>> "SELECT * FROM gallery WHERE views=MAX(views);"
>>
>> In other words, I want to find the gallery with the most views.
>>
>> Any suggestions on how to achieve this with Torque 3.2 and MySQL would
>> be
>> greatly appreciated.
>>
>> Regards,
>> Trevor
>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
>> For additional commands, e-mail: torque-user-help@db.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org
>
>


---------------------------------------------------------------------
Trevor Miller
Developer
Spiraleye Studios
trevor@spiraleye.com
www.spiraleye.com

Important Notice: Important restrictions, qualifications and
disclaimers ("The Disclaimer") apply to this email. To read this
click on the following address: http://www.spiraleye.co.za/legal
The Disclaimer forms part of the content of this email in terms
of section 11 of the South African Electronic Communications and
Transactions Act, 25 of 2002.


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message