Re: QueryByExample - querying on same column with different values

2006-04-25 Thread Jeff Butler
The Abator query by example facility does not support this kind of where clause currently, so you'll have to do the operation 4 times (sorry about that).   Once we get support for nested iterate tags into iBATIS, then I'll change Abator so that you can generate arbitrarily complex where clauses.  

QueryByExample - querying on same column with different values

2006-04-25 Thread Espen Rydningen
Hi, I'm new to Ibatis, so if this is a stupid question, you'll have to excuse me. I've downloaded Abator for Eclipse and generated maps/DAOs and models. In this example it's an agreement table between a buyer and a seller. This table also got a status field the buyer and the seller for each agreem

Re: QueryByExample

2006-03-20 Thread Jeff Butler
Abator does not generate any code that joins tables - you'll have to write a custom query for that.   Jeff Butler   On 3/20/06, Emiliano Armellin <[EMAIL PROTECTED]> wrote: hello,which is the best pattern to join two or more tables using a QueryByExample strategy?thanks -- Emilia

Re: QueryByExample

2006-03-20 Thread Emiliano Armellin
hello, which is the best pattern to join two or more tables using a QueryByExample strategy? thanks -- Emiliano Armellin W_ www.ateikon.com @_ [EMAIL PROTECTED] T_ +39 0422 452101

Re: QueryByExample

2006-03-19 Thread DaqiQian2
Jeff,   Thanks for help. It seems that we can only use either 'or' or 'and' in a single queryByExample query.   Tony

Re: QueryByExample

2006-03-17 Thread Jeff Butler
Query 1:   CouponExample example = new CouponExample(); example.setBarcode(myBarcode); example.setBarcode_Indicator(CouponExample.EXAMPLE_EQUALS); example.setExpirationDate(myExpirationDate); example.setExpirationDate_Indicator(CouponExample.EXAMPLE_EQUALS);   Query 2:   CouponExample example = n

QueryByExample

2006-03-17 Thread Tony Qian
All, Just started to use Abator to generate DAO codes for iBATIS.  Have a question on queryByExample. I have table coupon { coupon_id, barcode, start_date, expiration_date, ...}.  start_date and expiration_date have DATE as JDBCType. database is MySql I have three queries. select * from