Return-Path: 
 <user-java-return-5632-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 26311 invoked from network); 23 Jan 2006 12:48:55 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 23 Jan 2006 12:48:55 -0000
Received: (qmail 32827 invoked by uid 500); 23 Jan 2006 12:48:53 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 32800 invoked by uid 500); 23 Jan 2006 12:48:52 -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 32789 invoked by uid 99); 23 Jan 2006 12:48:51 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jan 2006 04:48:51 -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 larry.meadors@gmail.com
 designates 66.249.82.202 as permitted sender)
Received: from [66.249.82.202] (HELO xproxy.gmail.com) (66.249.82.202)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 23 Jan 2006 04:48:50 -0800
Received: by xproxy.gmail.com with SMTP id s19so602477wxc
        for <user-java@ibatis.apache.org>;
 Mon, 23 Jan 2006 04:48:29 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=i6HDBuIPX/VG9m/BDt1JjKmcdQJbmnBwrdd7m9K/u8Sx1onYw6aL2sn+9dJkYirPB+3F5ee8CST+Jp0lUb/yil8fFUIELV+NbGYNNgKLHYA32715cpRupaB/9HCfcocdGYk3hWEN3YSKVkbS4mmb3EAqjplfn/xmt91ThdcOGhc=
Received: by 10.70.100.7 with SMTP id x7mr6134168wxb;
        Mon, 23 Jan 2006 04:48:29 -0800 (PST)
Received: by 10.70.75.18 with HTTP; Mon, 23 Jan 2006 04:48:29 -0800 (PST)
Message-ID: <a10a823c0601230448s7a4aa2f3gac60ff504335bee8@mail.gmail.com>
Date: Mon, 23 Jan 2006 05:48:29 -0700
From: Larry Meadors <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: SQL query with "greater and equal" and "less and equal"
In-Reply-To: <c593b8750601221257v7fbf69c7k5b2a56bcec12807d@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <20060122202904.58510.qmail@web60713.mail.yahoo.com>
	 <c593b8750601221257v7fbf69c7k5b2a56bcec12807d@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This will work, too:

<select id=3D"getRawAttendanceRecordListRange"
resultMap=3D"rawAttendanceRecordResult"
parameterClass=3D"searchAttendanceRecords">
   select * from RAWATTENDANCERECORD
   where logDate &gt;=3D #fromDate#
     and logDate &lt;=3D #toDate#
</select>

Larry


On 1/22/06, Jeff Butler <jeffgbutler@gmail.com> wrote:
> <select id=3D"getRawAttendanceRecordListRange"
> resultMap=3D"rawAttendanceRecordResult"
> parameterClass=3D"searchAttendanceRecords">
>    select * from RAWATTENDANCERECORD
>    where logDate <![CDATA[ >=3D ]]> #fromDate#
>      and logDate <![CDATA[ <=3D ]]> #toDate#
> </select>
>
> You need to enclose the <=3D and >=3D operators in XML CDATA sections to =
avoid
> breaking the XML syntax.
>
> The <isGreaterEqual> and is <isLessEqual> tags are for generating dynamic
> SQL based on run time values - not what you're doing here.
>
> Jeff Butler
>
>
>
> On 1/22/06, Erik Kron <erik_kron@yahoo.com> wrote:
> > I have a table called rawattendancerecord.
> >
> > There is a column in the table called logDate;
> >
> > I want to be able to return log dates between 2 give
> > search date criteria. E.g. dates between fromDate and
> > toDate.
> >
> >
> > I can do a search from the command line (mysql) with
> > the following commands to return the right values.
> > e.g.
> >
> > select * from rawattendancerecord where
> > logDate>=3D'2005-10-10' and logDate<=3D'2006-01-15';
> >
> >
> > How can I represent a similar query in ibatis?
> >
> > In my RawAttendanceRecord.xml: (I am passing my search
> > range (from and to value) with fromDate to toDate
> > (properties) in the searchAttendanceRecords class.
> >
> > <select id=3D"getRawAttendanceRecordListRange"
> > resultMap=3D"rawAttendanceRecordResult"
> > parameterClass=3D"searchAttendanceRecords">
> >    select * from RAWATTENDANCERECORD where ...
> >
> > </select>
> >
> > I just do not know the syntax to use. I have read
> > about <isGreaterEqual> and <isLessEqual>. But I cannot
> > seem to be able to use them appropriately.
> >
> > Any help will be appreciated. I tried to search the
> > FAQ section, but the site is currently down.
> >
> > Regards,
> > Erik
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Tired of spam?  Yahoo! Mail has the best spam protection around
> > http://mail.yahoo.com
> >
>
>