Yes, that is what I meant. Someone have any ideas how to start? It would appreciate if someone gives me some tips.
Regards Sophia -----Original Message----- From: Jeff Butler [mailto:[EMAIL PROTECTED] Sent: donderdag 19 juni 2008 16:48 To: user-java@ibatis.apache.org Subject: Re: Problem with my query. I think you mean that you don't know how to build this query with *ibator* generated objects. Ibator does not support this type of query - you will need to hand code the query (the best alternative), or do two different queries with the ibator objects. Jeff Butler On Thu, Jun 19, 2008 at 9:06 AM, Sophia <[EMAIL PROTECTED]> wrote: > Thanks for your repley, > > The problem is, I dont know how to build this query in Ibatis. > > select * from ACCOUNT where NUMBER in > (select NUMBER from ACCOUNT where substr(ACCOUNT,5,4) between '2002' and > '2006') > > This must be build in ibatis. The question is, i have not yet build something > like this with a "in" statement as query. > The query at the end of my previous message is just a piece of it. > I use DB2 as database. > > Regards, > Sophia > > >>----- Oorspronkelijk bericht ----- >>Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] >>Verzonden: donderdag, juni 19, 2008 03:11 PM >>Aan: user-java@ibatis.apache.org >>Onderwerp: Re: Problem with my query. >> >>I'm not entirely sure what you're trying to do, as that query at the end >>of your message looks like a good solution to me. It sounds like you are >>trying to do something more complicated. Depending on your DBMS, you can >>try something like this: >> >>select ACCOUNT.* from ACCOUNT, >> (select NUMBER from ACCOUNT where substr(ACCOUNT, 5, 4) between >>'2002' and '2006') NUM >>where ACCOUNT.NUMBER = NUM.NUMBER >> >>I'm sure any number of people can give you any number of ways to optimize >>this. Is the error that you get coming from your DBMS or ibatis? >> >>-David >> >> >> >>From: >>"Sophia" <[EMAIL PROTECTED]> >>To: >>user-java@ibatis.apache.org >>Date: >>06/19/2008 08:55 AM >>Subject: >>Problem with my query. >> >> >> >>Hallo everyone, >> >>I have a problem with my query, can someone help me further >>This is the query that I want to use in ibatis. >> >>select * from ACCOUNT where NUMBER in >>(select NUMBER from ACCOUNT where substr(ACCOUNT,5,4) between '2002' and >>'2006?) >> >> >>This is my source: >> >> >>try { >>dao.ACCOUNTDAO accountList2Dao = >>(dao.ACCOUNTDAO)DaoManagerRequester.getDaoManager().getDao(dao.ACCOUNTDAO.class); >>model.ACCOUNTExample account2Example = new model.accountExample(); >> >>List resultList6 = accountList2Dao.selectByAccountList2(account2Example); >>account2Example.createCriteria().andNumberDateBetween(startdate, enddate); >> >>List resultList6 = accountList2Dao.selectByAccountList2(account2Example); >> >>... >> >>} catch ... >> >> >>This works, and it gives me this: >> >>select * from ACCOUNT where substr(ACCOUNT,5,4) between '2002' and '2006' >> >> >>Any suggestions? >> >> >>Regards, >>Sophia >> >> >> >> >> > > >
