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
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
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
this still works in IB3.
Give us more of your code to figure out where the issue really is.
Show us the full sqlmap/annotation as well as the calling method.
N
On Wed, Apr 7, 2010 at 8:46 AM, Joram Barrez joram.bar...@gmail.com wrote:
Hi All,
I was wondering if this is possible with iBatis
In iBATIS 2, you would use ${value}. Maybe this still holds for version 3?
Niels
On 7 April 2010 16:46, Joram Barrez joram.bar...@gmail.com wrote:
Hi All,
I was wondering if this is possible with iBatis 3:
select id=selectTableCount parameterType=string resultType=long
select count(*)
The format did change, here is the new format:
select id=selectCountBySourceKey parameterType=String
resultType=Integer
/* contents.Content.selectCountBySourceKey */
SELECT COUNT(*)
FROMcontents
WHERE source_key =