Return-Path: 
 <user-java-return-13609-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 52640 invoked from network); 1 Feb 2008 16:32:07 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 1 Feb 2008 16:32:07 -0000
Received: (qmail 9893 invoked by uid 500); 1 Feb 2008 16:31:56 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 9883 invoked by uid 500); 1 Feb 2008 16:31:56 -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 9868 invoked by uid 99); 1 Feb 2008 16:31:56 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 08:31:55 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: local policy)
Received: from [206.66.179.41] (HELO mssn1.peapod.com) (206.66.179.41)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 01 Feb 2008 16:31:42 +0000
Received: from utln2.internal.peapod.com (utln2.internal.peapod.com
 [10.211.211.126])
	by mssn1.peapod.com (8.13.8+Sun/8.12.2) with SMTP id m11GVXVP011055
	for <user-java@ibatis.apache.org>; Fri, 1 Feb 2008 10:31:33 -0600 (CST)
Received: from utln2.internal.peapod.com (localhost [127.0.0.1])
	by utln2.internal.peapod.com (8.12.11/8.12.11) with ESMTP id m11GUpQH018763
	(version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NO)
	for <user-java@ibatis.apache.org>; Fri, 1 Feb 2008 10:30:51 -0600
Received: (from prayer@localhost)
	by utln2.internal.peapod.com (8.12.11/8.12.11/Submit) id m11GUoqR018762
	for user-java@ibatis.apache.org; Fri, 1 Feb 2008 10:30:50 -0600
X-Authentication-Warning: utln2.internal.peapod.com: prayer set sender to
 bbalmer@peapod.com using -f
From: bbalmer@peapod.com
To: user-java@ibatis.apache.org
Subject: Re: My first dynamic statement
Date: 01 Feb 2008 10:30:50 -0600
X-Mailer: Prayer v1.0.18
X-Originating-IP: [10.11.8.14]
In-Reply-To: <000f01c864ef$00730b40$0401a8c0@opacreims.local>
Message-ID: <Prayer.1.0.18.0802011030500.18747@utln2.internal.peapod.com>
References: <000f01c864ef$00730b40$0401a8c0@opacreims.local>
Mime-Version: 1.0
Content-Type: text/plain; format=flowed; charset=ISO-8859-1
X-Virus-Checked: Checked by ClamAV on apache.org

Your property names don't match what you have between ##.  How about:

              <isNotNull prepend="AND" property="eced">
                   eced=#eced#
              </isNotNull>
              <isNotNull prepend="AND" property="demc">
                 demc=#demc#
              </isNotNull>



On Feb 1 2008, FranT wrote:

>Hi there, i'm new ti iBatis and need help for my first dynamic statement.
>Here it is:
> 
> 
><resultMap id="getDynam" class="my.ft.kcaldos">
>        <result property="dndl" column="DNDL"/>
>        <result property="ncal" column="NCAL"/>
>        <result property="datcom" column="DATCOM"/>
>    </resultMap>
>        
>    <select id="dynamis" parameterClass="java.util.Map"
>                         resultMap="getDynam">
>          SELECT dndl, ncal, datcom from kcaldos 
>          <dynamic prepend="WHERE">
>              <isNotNull prepend="AND" property="eced">
>                   eced=#ec#
>              </isNotNull>
>              <isNotNull prepend="AND" property="demc">
>                 demc=#dem#
>              </isNotNull>
>          </dynamic>
>                  where datcom > to_date('01/01/2007','DD/MM/YYYY')
>                  order by dndl
>   </select>
> 
>When running it, i stil get;
> 'SELECT dndl, ncal, datcom from kcaldos where datcom >
>to_date('01/01/2007','DD/MM/YYYY') order by dndl'
>even when the two properties (eced and demc) are not null.
>May be i'm missing something somewhere ? Thanks in advance.
>
>
>