Nathan
Good point, I knew about it (and used it) but it slipped my mind.
Cheers
François
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.
>
> #{foo} == jdbc set parameter
> ${foo} == string substitution before the prepared statement
>
> Nathan
>
> 2010/4/7 François Schiettecatte <[email protected]>:
>> The format did change, here is the new format:
>>
>> <select id="selectCountBySourceKey" parameterType="String"
>> resultType="Integer">
>>
>> /* contents.Content.selectCountBySourceKey */
>> SELECT COUNT(*)
>> FROM contents
>> WHERE source_key = #{value}
>>
>> </select>
>>
>>
>> François
>>
>> On Apr 7, 2010, at 5:54 PM, Niels Beekman wrote:
>>
>>> In iBATIS 2, you would use ${value}. Maybe this still holds for version 3?
>>>
>>> Niels
>>>
>>> On 7 April 2010 16:46, Joram Barrez <[email protected]> wrote:
>>> Hi All,
>>>
>>> I was wondering if this is possible with iBatis 3:
>>>
>>> <select id="selectTableCount" parameterType="string" resultType="long" >
>>> select count(*) from ${tableName}
>>> </select>
>>>
>>> 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)?
>>>
>>>
>>> Regards,
>>>
>>> Joram
>>>
>>> ---------------------------------------------------------------------
>>> To unsubscribe, e-mail: [email protected]
>>> For additional commands, e-mail: [email protected]
>>>
>>>
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: [email protected]
>> For additional commands, e-mail: [email protected]
>>
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
