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]
