ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michael Laccetti" <mich...@s2g-limited.com>
Subject RE: Select count(*) in a resultMap
Date Fri, 27 Jan 2006 20:37:03 GMT
Forgot about that bit.  Thanks.

Based on that, I've come up with this:

<resultMap id="get-channel-count" class="channelCount">
      <result property="existing" column="existingCount" />
      <result property="pending" column="channel"
select="getChannelPendingCount" />
   </resultMap>

   <select id="getChannelPendingCount" resultClass="java.lang.Integer">
      SELECT COUNT(*) as pendingCount FROM scrimbot_pending_channels WHERE
channel=#value#
   </select>

   <statement id="getChannelCount" resultMap="get-channel-count">
      SELECT COUNT(*) as existingCount, channel FROM scrimbot_channels WHERE
channel=#value# GROUP BY channel
   </statement>

I'm trying to get whether or not the channel exist in either the existing or
pending tables.  I can see that the getChannelCount statement is called, but
the nested select is not happening, and I get a null object back.  Any
ideas?

Mike

-----Original Message-----
From: Ted Schrader [mailto:tschrader@gmail.com] 
Sent: January 27, 2006 3:10 PM
To: user-java@ibatis.apache.org
Subject: Re: Select count(*) in a resultMap

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