RE: Problem with my query.

2008-06-19 Thread Sophia
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

Problems inserting into a oject view

2008-06-19 Thread Vinaya Tirikkovalluru
Hi, I have a situation where I need to insert data into an Object view. I am getting the following error ... Caused by: com.ibatis.sqlmap.client.SqlMapException: There is no statement named NECXADM_SUPPLY_OBJVW.abatorgenerated_insert in this SqlMap. at com.ibatis.sqlmap.engine.impl.Sql

Serilize objects

2008-06-19 Thread Wolf-Dieter Mische
Hi, does anybody know how to serilize an object to the database? greetz wolle -- Ist Ihr Browser Vista-kompatibel? Jetzt die neuesten Browser-Versionen downloaden: http://www.gmx.net/de/go/browser

Re: Problem with my query.

2008-06-19 Thread Jeff Butler
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

Re: Problem with my query.

2008-06-19 Thread Sophia
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

Re: Problem with my query.

2008-06-19 Thread David_Greenberg
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 NU

Problem with my query.

2008-06-19 Thread Sophia
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 accountLi