Your property names don't match what you have between ##. How about:
eced=#eced#
demc=#demc#
On Feb 1 2008, FranT wrote:
Hi there, i'm new ti iBatis and need help for my first dynamic state
Hi there, i'm new ti iBatis and need help for my first dynamic statement.
Here it is:
SELECT dndl, ncal, datcom from kcaldos
eced=#ec#
demc
1].value#,
'MMDD')
c.CORP_ID = #fields[2].value#
)
-Original Message-
From: John Chien [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 15, 2005 9:38 AM
To: user-java@ibatis.apache.org
Subject: Re: Dynamic statem
rstPrepend="true" on the dynamic-tag, this causes iBATIS
to skip the first prepend encountered.
Hope this helps,
Niels
From: John Chien [mailto:[EMAIL PROTECTED]
Sent: maandag 14 november 2005 18:30
To: user-java@ibatis.apache.org
Subject: R
user-java@ibatis.apache.org
Subject: Re: Dynamic statement
Nathan:
How can I turn on the logging of ibatis ?
The statement just does not run.
I think the problem is that the three statement in the
will produce something like (OR OR OR )
Thus the where clause will become like:
WHERE p.CORP_ID = c.C
AM, John Chien wrote: Dear Sir: I have a question related to dynamic statement As shown below, I have a select statement for data in three tables The GUI has three input fields. Their value can not be determined before hand. Besides of doing the join of the tables, I wa
ot to hard code the array indices.
nathan
On Nov 14, 2005, at 9:53 AM, John Chien wrote:
Dear Sir:
I have a question related to dynamic statement
As shown below, I have a select statement for data in three tables
The GUI has three input fields. Their val
java bean with the 3
properties ( year, deposit, corp_id), or a map of these. This will
enable you not to hard code the array indices.
nathan
On Nov 14, 2005, at 9:53 AM, John Chien wrote:
Dear Sir:
I have a question related to dynamic statement
As shown below, I have a select statement f
Dear Sir:
I have a question related to dynamic statement
As shown below, I have a select statement for data in three tables
The GUI has three input fields. Their value can not be determined before
hand.
Besides of doing the join of the tables, I want to have a dynamic where
clause so that
