Return-Path: 
 <user-java-return-6112-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 32141 invoked from network); 27 Feb 2006 20:04:03 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 27 Feb 2006 20:04:03 -0000
Received: (qmail 53648 invoked by uid 500); 27 Feb 2006 20:03:50 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 53620 invoked by uid 500); 27 Feb 2006 20:03:50 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 53592 invoked by uid 99); 27 Feb 2006 20:03:49 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Feb 2006 12:03:49 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: local policy)
Received: from [141.211.14.78] (HELO pushingtin.mr.itd.umich.edu)
 (141.211.14.78)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 27 Feb 2006 12:03:49 -0800
Received: from [141.214.41.77] (host-77.subnet-41.med.umich.edu
 [141.214.41.77])
	by pushingtin.mr.itd.umich.edu (smtp) with ESMTP id k1RK3RSn023858
	for <user-java@ibatis.apache.org>; Mon, 27 Feb 2006 15:03:27 -0500
Message-ID: <44035B42.4040903@umich.edu>
Date: Mon, 27 Feb 2006 15:04:18 -0500
From: Henry Lu <zhlu@umich.edu>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: user-java@ibatis.apache.org
Subject: Re: Help me with this please
References: <2F038EED15EF804A84175613FD39FA420A4FBC@exchdal04.Parsons.com>
In-Reply-To: <2F038EED15EF804A84175613FD39FA420A4FBC@exchdal04.Parsons.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

 >><isNotNull property="sortBy">

>>  ORDER BY #sortBy#
>></isNotNull>

replace this with following:

<isNotNull property="sortBy">
  ORDER BY $sortBy$
</isNotNull>


-Henry

Vu, Thai wrote:

>I cannot make the ORDER BY clause work.
>
>public class RequirementsSummaryCondBean {
>	private String  majcom;
>	private Integer budgetProject;
>	private String  location;
>	private String  round;
>	private String  sortBy;
>    // getter & setter methods here
>}
>
><resultMap id="select-requirement-result"
> 
>class="com.parsons.bmt.financial.beans.RequirementsSummaryBean">
>  <result property="projectref"     column="PROJECTREF" />
>  <result property="projectid"      column="PROJECTID" />
>  <result property="recname"        column="RECNAME" />
>  <result property="location"       column="LOCATION_X" />
>  <result property="oac"            column="OAC" />
>  <result property="majcom"         column="MAJCOM" />
>  <result property="budgetProject"  column="BUDGETPROJECT" />
>  <result property="baan"           column="BAAN" />
>  <result property="subaction"      column="SUBACTION" />
>  <result property="title"          column="TITLE" />
>  <result property="required"       column="REQUIRED" />
>  <result property="funded"         column="FUNDED" />
>  <result property="savedDeltas"    column="SAVED_DELTAS" />
>  </resultMap>
>  <select id="getRequirements"
> 
>parameterClass="com.parsons.bmt.financial.beans.RequirementsSummaryCondB
>ean"
>          resultMap="select-requirement-result">
>    <![CDATA[
>      SELECT p.projectref, p.projectid,
>             (SELECT base4digit || ' - ' || base FROM gl_base WHERE
>baseid = p.base) AS recname,
>             (SELECT location FROM gl_location WHERE code = p.location)
>AS location_X,
>             (SELECT oac FROM gl_execcommand WHERE majcom = p.majcom) AS
>oac,
>             majcom, budgetproject, baan, subaction, title,
>             (SELECT NVL(SUM(NVL(y2006, 0) + NVL(y2007, 0) + NVL(y2008,
>0) + NVL(y2009, 0) + NVL(y2010, 0) + NVL(y2011, 0)), 0) 
>                FROM rm_funding WHERE projectref = p.projectref) AS
>required,
>             NVL(funded, 0) AS funded, saved_deltas
>        FROM rm_project p
>    ]]>
>    <dynamic prepend="WHERE">
>      <isNotNull prepend="AND" property="majcom">
>        majcom = #majcom#
>      </isNotNull>
>      <isNotNull prepend="AND" property="budgetProject">
>        p.budgetproject = #budgetProject#
>      </isNotNull>
>      <isNotNull prepend="AND" property="location">
>        p.location = #location#
>      </isNotNull>
>      <isNotNull prepend="AND" property="round">
>        p.round = #round#
>      </isNotNull>
>    </dynamic>
>    <dynamic prepend="ORDER BY">
>      <isNotNull prepend=", " property="sortBy">
>        #sortBy#
>      </isNotNull>
>    </dynamic>
>  </select>
>
>sqlMap.queryForList("getRequirements", requirementsSummaryCondBean);
>
>It seems to me that the ORDER BY clause doesn't exist because the result
>doesn't change (I'm sure that the `sortBy' property in the
>requirementsSummaryCondBean is not null). I tried that case and this
>case (without the <dynamic> tag):
>
><isNotNull property="sortBy">
>  ORDER BY #sortBy#
></isNotNull>
>
>And both of them don't work.
>
>
>
>
>  
>