Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (nike.apache.org: domain of fschiettecatte@gmail.com
 designates 209.85.212.53 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=content-type:mime-version:subject:from:in-reply-to:date
         :content-transfer-encoding:message-id:references:to:x-mailer;
        b=GWogBMEqEprvuTtpanYKTmJhTv7hzQ30lmo6ffl2Rk64+RrjbwN5u8xvl4Yby2V468
         G/HP5eDsThZ1Mt8Y2deWMFA5GTtTQ0fjzvWIAp6c+6HNUbbRg1f9MalprLUJ0+VzwT1G
         c5V6Xxd8jtRu33/TM01TmN8GKKzEiXeyeOsdw=
Content-Type: text/plain; charset=iso-8859-1
Mime-Version: 1.0 (Apple Message framework v1078)
Subject: Re: Dynamic table replacement possible in iBatis3 ?
From: =?iso-8859-1?Q?Fran=E7ois_Schiettecatte?= <fschiettecatte@gmail.com>
In-Reply-To: <l2z2f55db671004080839h919fe5a9rdf4000e4d5e618f6@mail.gmail.com>
Date: Thu, 8 Apr 2010 14:13:17 -0400
Content-Transfer-Encoding: quoted-printable
Message-Id: <12863ABE-0A9B-4FEC-BE92-CF3A63C2930F@gmail.com>
References: <h2h5656613a1004070746p9c7eeeecs1fe07db928f4da51@mail.gmail.com>
  <n2s99df9b31004071454j345c6b83q8fb2c8df3870bc3d@mail.gmail.com>
  <85B80E11-F26E-48DC-B432-6F3CBA9D1F06@gmail.com>
 <l2z2f55db671004080839h919fe5a9rdf4000e4d5e618f6@mail.gmail.com>
To: user-java@ibatis.apache.org

Nathan

Good point, I knew about it (and used it) but it slipped my mind.

Cheers

Fran=E7ois

On Apr 8, 2010, at 11:39 AM, Nathan Maves wrote:

> You are only half correct.  The format that you just used as an
> example is only for parameters.  He is looking for the string
> substitution which also changed.
>=20
> #{foo} =3D=3D jdbc set parameter
> ${foo} =3D=3D string substitution before the prepared statement
>=20
> Nathan
>=20
> 2010/4/7 Fran=E7ois Schiettecatte <fschiettecatte@gmail.com>:
>> The format did change, here is the new format:
>>=20
>>        <select id=3D"selectCountBySourceKey" parameterType=3D"String" =
resultType=3D"Integer">
>>=20
>>                /* contents.Content.selectCountBySourceKey */
>>                SELECT  COUNT(*)
>>                FROM    contents
>>                WHERE   source_key =3D #{value}
>>=20
>>        </select>
>>=20
>>=20
>> Fran=E7ois
>>=20
>> On Apr 7, 2010, at 5:54 PM, Niels Beekman wrote:
>>=20
>>> In iBATIS 2, you would use ${value}. Maybe this still holds for =
version 3?
>>>=20
>>> Niels
>>>=20
>>> On 7 April 2010 16:46, Joram Barrez <joram.barrez@gmail.com> wrote:
>>> Hi All,
>>>=20
>>> I was wondering if this is possible with iBatis 3:
>>>=20
>>> <select id=3D"selectTableCount" parameterType=3D"string" =
resultType=3D"long" >
>>>    select count(*) from ${tableName}
>>> </select>
>>>=20
>>> The problem is that the string ${tableName} is not replaced by the
>>> parameter, leadin to a 'select count(*) from null' at runtime.
>>> Am I doing something wrong here or is this feature not yet =
implemeted
>>> (as it worked on iBatis2 according to Google)?
>>>=20
>>>=20
>>> Regards,
>>>=20
>>> Joram
>>>=20
>>> =
---------------------------------------------------------------------
>>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>>=20
>>>=20
>>=20
>>=20
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>=20
>>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
> For additional commands, e-mail: user-java-help@ibatis.apache.org
>=20


---------------------------------------------------------------------
To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
For additional commands, e-mail: user-java-help@ibatis.apache.org