Return-Path: 
 <user-java-return-16337-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 51729 invoked from network); 20 Feb 2009 20:53:05 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 Feb 2009 20:53:05 -0000
Received: (qmail 2809 invoked by uid 500); 20 Feb 2009 20:53:03 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 2790 invoked by uid 500); 20 Feb 2009 20:53:03 -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 2781 invoked by uid 99); 20 Feb 2009 20:53:03 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Feb 2009 12:53:03 -0800
X-ASF-Spam-Status: No, hits=2.2 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of ashish.kulkarni13@gmail.com
 designates 74.125.44.155 as permitted sender)
Received: from [74.125.44.155] (HELO yx-out-1718.google.com) (74.125.44.155)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 20 Feb 2009 20:52:55 +0000
Received: by yx-out-1718.google.com with SMTP id 3so488061yxi.6
        for <user-java@ibatis.apache.org>;
 Fri, 20 Feb 2009 12:52:34 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=gamma;
        h=domainkey-signature:mime-version:received:in-reply-to:references
         :date:message-id:subject:from:to:content-type;
        bh=VDPQmQexeRIIARBajANvrN/bKT0Za2Pc8SPQFzFWMCQ=;
        b=lj17h/TQX1ggazNL1LzxFP3B5i8n5GR2gu0kKLidqPaNTzy+Te6X87LD09+oeT8zAH
         mhp4K/Y9ivQZwK6TMb6+4X2uKZBsPW+J0K6CbMJVbKZbBbfbqkjcHeThnlrOvVckemKv
         cslMWpI+jfPSNh8Cxwi2YqKIwFzf4j4D/nvS4=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=ugRBkGYaHdbtGCUVIV9LJYfP5BeB96GmzB2mOHalPPe+h0rSO85qx0aPfWN214V4GO
         3krqORfJUWcoydPykbyJyzGQ2cuvygkaQ+HoWFU+tE8bjR7DSpim6T1SHnILjg1mmYk9
         CSC0rjPzutaHC8zc4dZu6Zg/dtzaEzcjLts/o=
MIME-Version: 1.0
Received: by 10.220.92.139 with SMTP id r11mr292469vcm.15.1235163154183; Fri,
	20 Feb 2009 12:52:34 -0800 (PST)
In-Reply-To: <a10a823c0902201247p5442abffvd0f3d498f91c70ee@mail.gmail.com>
References: <878c6f8e0902201244y2aa0c1a4u745ce6b86c95e825@mail.gmail.com>
	 <a10a823c0902201247p5442abffvd0f3d498f91c70ee@mail.gmail.com>
Date: Fri, 20 Feb 2009 15:52:34 -0500
Message-ID: <878c6f8e0902201252g45ec9d4wb7ce8f207c3f83b5@mail.gmail.com>
Subject: Re: Issue with SQL query in ibatis
From: Ashish Kulkarni <ashish.kulkarni13@gmail.com>
To: user-java@ibatis.apache.org, larry.meadors@gmail.com
Content-Type: multipart/alternative; boundary=001636284c740b74e704635fd505
X-Virus-Checked: Checked by ClamAV on apache.org

--001636284c740b74e704635fd505
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hican you please explain what do you there are no parameter markers

<select id="getEnvNames"
resultClass="com.pfizer.maps.base.data.file.EnvNames"
parameterClass="com.pfizer.maps.base.data.file.EnvNames">
SELECT TYPE, AS400NAME, ENVNAME, ENVDESC, DISABLED, INIPROG,
INIPGMLIB, USERID, PASS_WRD, MAPSLOGINR FROM EnvNames WHERE TYPE =tYPE and
AS400NAME =aS400Name and ENVNAME=eNVNAME
</select>

i have TYPE=tYPE, which i expect to work as marker, the EnvNames class has
get and set method for tYPE, aS400NAME
What am i suppose to do to modify this query


On Fri, Feb 20, 2009 at 3:47 PM, Larry Meadors <larry.meadors@gmail.com>wrote:

> The first mapped statement doesn't appear to have any parameter
> markers in it. :-/
>
> Larry
>

--001636284c740b74e704635fd505
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi<div>can you please explain what do you there are no parameter markers</d=
iv><div><br></div><div><span class=3D"Apple-style-span" style=3D"border-col=
lapse: collapse; "><div>&lt;select id=3D&quot;getEnvNames&quot;</div><div><=
span style=3D"white-space: pre; ">		</span>resultClass=3D&quot;com.pfizer.m=
aps.base.data.file.EnvNames&quot;</div>
<div><span style=3D"white-space: pre; ">		</span>parameterClass=3D&quot;com=
.pfizer.maps.base.data.file.EnvNames&quot;&gt;</div><div><span style=3D"whi=
te-space: pre; ">		</span>SELECT TYPE, AS400NAME, ENVNAME, ENVDESC, DISABLE=
D, INIPROG,</div>
<div><span style=3D"white-space: pre; ">		</span>INIPGMLIB, USERID, PASS_WR=
D, MAPSLOGINR FROM EnvNames WHERE TYPE =3DtYPE and</div><div><span style=3D=
"white-space: pre; ">		</span>AS400NAME =3DaS400Name and ENVNAME=3DeNVNAME<=
/div><div>
&lt;/select&gt;</div><div><br></div><div>i have TYPE=3DtYPE, which i expect=
 to work as marker, the EnvNames class has get and set method for tYPE, aS4=
00NAME</div><div>What am i suppose to do to modify this query</div><div><br=
>
</div></span></div><div><br><div class=3D"gmail_quote">On Fri, Feb 20, 2009=
 at 3:47 PM, Larry Meadors <span dir=3D"ltr">&lt;<a href=3D"mailto:larry.me=
adors@gmail.com">larry.meadors@gmail.com</a>&gt;</span> wrote:<br><blockquo=
te class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc so=
lid;padding-left:1ex;">
The first mapped statement doesn&#39;t appear to have any parameter<br>
markers in it. :-/<br>
<font color=3D"#888888"><br>
Larry<br>
</font></blockquote></div><br></div>

--001636284c740b74e704635fd505--