RE: Dynamic statement

2005-11-15 Thread Voorhoeve, Niels {PBG}
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

Re: Dynamic statement

2005-11-15 Thread John Chien
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

RE: Dynamic statement

2005-11-14 Thread Niels Beekman
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

Re: Dynamic statement

2005-11-14 Thread Nathan Maves
John,The WIKI is always a great place to start :)http://opensource2.atlassian.com/confluence/oss/display/IBATIS/Homehere is the specific FAQ about logging.http://opensource2.atlassian.com/confluence/oss/display/IBATIS/How+do+I+get+SqlMapClient+to+log+SQL+statementsTry to get that to work first.I wo

Re: Dynamic statement

2005-11-14 Thread John Chien
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.CORP_ID AND c.CORP_ID = a.CORP_ID AND (OR OR O

Re: Dynamic statement

2005-11-14 Thread Nathan Maves
First off by "not run well" do you mean that there is an error? if so please post it. Second turn on logging to make sure the sql appears as you would expect it to. Third it appears that you are sending in an array of objects as parameters. I would suggest that you use a java bean with