ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Schrader <tschra...@gmail.com>
Subject Re: Select count(*) in a resultMap
Date Fri, 27 Jan 2006 20:10:29 GMT
Hi Michael,

Try giving the resulting column an alias:

SELECT COUNT(*) AS MY_TOTAL FROM TABLE.

Then, use "MY_TOTAL" in your result map configuration.

Ted

On 27/01/06, Michael Laccetti <michael@s2g-limited.com> wrote:
>
>
>
> Is it possible to do a 'select count(*) from table' and then reference that
> value in a result map?  I've been searching around and trying to get it to
> work to no avail.
>
>
>
> Mike

Mime
View raw message