Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 27571 invoked from network); 27 Jan 2006 20:11:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 27 Jan 2006 20:11:14 -0000 Received: (qmail 46256 invoked by uid 500); 27 Jan 2006 20:10:51 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 46240 invoked by uid 500); 27 Jan 2006 20:10:50 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 46229 invoked by uid 99); 27 Jan 2006 20:10:50 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jan 2006 12:10:50 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (asf.osuosl.org: domain of tschrader@gmail.com designates 66.249.82.200 as permitted sender) Received: from [66.249.82.200] (HELO xproxy.gmail.com) (66.249.82.200) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Jan 2006 12:10:49 -0800 Received: by xproxy.gmail.com with SMTP id s19so410980wxc for ; Fri, 27 Jan 2006 12:10:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=HX1Kb94t+G9qkkqyfL/v8z6zI04/l59nrUmgW/x+cVWWrRY+iq6+c36lOFF5uhABfe9sUyfMiXGTHjfvVULN+6QP8ZzoRUmow2oequB7blqEgeZE8Bb9E3dwUzdteQ/DlwEWBJvFhmWeTisrLjduEDFoWxKBS85YpRd5gcRvv18= Received: by 10.70.28.9 with SMTP id b9mr3924096wxb; Fri, 27 Jan 2006 12:10:29 -0800 (PST) Received: by 10.70.96.7 with HTTP; Fri, 27 Jan 2006 12:10:29 -0800 (PST) Message-ID: <27c1a34f0601271210u790830c1x@mail.gmail.com> Date: Fri, 27 Jan 2006 15:10:29 -0500 From: Ted Schrader To: user-java@ibatis.apache.org Subject: Re: Select count(*) in a resultMap In-Reply-To: <011101c6237d$43725b90$0201000a@dumdum> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <011101c6237d$43725b90$0201000a@dumdum> X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N 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 wrote: > > > > Is it possible to do a 'select count(*) from table' and then reference th= at > value in a result map? I've been searching around and trying to get it t= o > work to no avail. > > > > Mike