Return-Path: Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm Delivered-To: mailing list ibatis-user-java@incubator.apache.org Received: (qmail 68500 invoked by uid 99); 18 Jan 2005 16:22:09 -0000 X-ASF-Spam-Status: No, hits=0.2 required=10.0 tests=HTML_90_100,HTML_MESSAGE X-Spam-Check-By: apache.org Received-SPF: pass (hermes.apache.org: local policy) Received: from yorktown.nielsenmedia.com (HELO yorktown.nielsenmedia.com) (206.113.192.17) by apache.org (qpsmtpd/0.28) with ESMTP; Tue, 18 Jan 2005 08:22:09 -0800 Received: from nmrflimg2.enterprisenet.org (nmrflimg2.enterprisenet.org [10.38.67.65]) by yorktown.nielsenmedia.com (8.12.10/8.12.8) with ESMTP id j0IGHo3x015981 for ; Tue, 18 Jan 2005 11:17:50 -0500 (EST) Received: from nmr001oldOWA01.enterprisenet.org (unverified) by nmrflimg2.enterprisenet.org (Content Technologies SMTPRS 4.3.14) with ESMTP id for ; Tue, 18 Jan 2005 11:22:05 -0500 Received: from nmr001oldmsx04.enterprisenet.org ([10.38.67.63]) by nmr001oldOWA01.enterprisenet.org with Microsoft SMTPSVC(6.0.3790.211); Tue, 18 Jan 2005 11:22:05 -0500 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C4FD79.D94C2915" Subject: RE: Qns abt using inside Thread-Index: AcT9dyq+P5OumsAAQByGGSnJQvjN+gAAljFw From: "Chen, Tim" To: X-OriginalArrivalTime: 18 Jan 2005 16:22:05.0344 (UTC) FILETIME=[D9663200:01C4FD79] X-Virus-Checked: Checked This is a multi-part message in MIME format. ------_=_NextPart_001_01C4FD79.D94C2915 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable There's a simple problem. If you look at the docs.. there is another statement that you can use to wrap what you have called: =20 if you add that instead of your 'where' it will be okay. -Tim ________________________________ From: Nilesh Bhattad [mailto:nilesh@outlinesys.com]=20 Sent: Tuesday, January 18, 2005 11:02 AM To: ibatis-user-java@incubator.apache.org Subject: Qns abt using inside =20 Please take a look at below select statement. =20 =20 The problem with this stmt is if only ActiveInactive is keyed in, the select stmt is resolved like below - =20 select ConsultantId, BlackListed, FirstName, LastName, HomeTelephone, EmailAddress, InterviewGrade, TotalYrsOfExp from Consultant where and ActiveInactive like ? order by FirstName, LastName =20 'and' is added in the stmt which makes it invalid query. How do I adjust the tags inside