Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cayenne.apache.org
Received-SPF: pass (athena.apache.org: domain of borut.bolcina@gmail.com
 designates 209.85.128.190 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=uNzm+5idGaazwV4U5RMUVbfF20qUb500v6xQiFVuAwFfzRnJJ7ESb57lWoRNjJL13nmQvyAQTXL9kuUbI9JorjG/Fij7VBBVWSgrvj1hn3HiJ3ZpBD/yntfGU6Ex5v4/jKCU1CG2EmET0exY0OcLobrLg/h+5nTc1MP4+9qf9aI=
Message-ID: <ee04ee7f0804220447i26987440ibed67ffd42077275@mail.gmail.com>
Date: Tue, 22 Apr 2008 13:47:47 +0200
From: "=?UTF-8?Q?Borut_Bol=C4=8Dina?=" <borut.bolcina@gmail.com>
To: user@cayenne.apache.org
Subject: Re: newbie question
In-Reply-To: <AD61AEA0-9373-4AE7-9840-7BCCAD4AA832@objectstyle.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_16770_30414602.1208864867261"
References: 
 <3DE2F3E894A5AE4D8EC2B2E94603BEA689D093@NLNHC011PEX.ubsamericas.net>
	 <AD61AEA0-9373-4AE7-9840-7BCCAD4AA832@objectstyle.org>

------=_Part_16770_30414602.1208864867261
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hello Andrus,

what is the elegant 3.0M3 Cayenne way to do select MAX?

Thanks,
Borut

2007/10/9 Andrus Adamchik <andrus@objectstyle.org>:

> Hi Jan,
>
> Looks like what you need is a SQLTemplate query:
>
>   http://cayenne.apache.org/doc/sqltemplate-query.html
>
> Here is a mockup code example:
>
>  SQLTemplate q = new SQLTemplate(SomeClass.class, "select MAX(id) from
> table");
>  q.setFetchingDataRows(true);
>
>  Map row = (Map) DataObjectUtils.objectForQuery(q);
>  Number id = (Number) row.values().iterator().next();
>
> (Cayenne 3.0 will be featuring more elegant API to achieve that, but still
> the code above should work just as well)
>
> Andrus
>

------=_Part_16770_30414602.1208864867261--