Re: How to define alias in

2009-03-27 Thread Brandon Goodin
ks for all your help. > > > From: Brandon Goodin > To: user-java@ibatis.apache.org > Date: 03/27/2009 12:29 PM > Subject: Re: How to define alias in > > -- > > > You know rethinking your statement. It makes no sense. You just showed us >

Re: How to define alias in

2009-03-27 Thread Jasmin Mehta
alias in SQL will work, Sorry I overlooked the SQL change earlier in first posting. And just saw the table column name in resultMap. I apologies. Thanks for all your help. From: Brandon Goodin To: user-java@ibatis.apache.org Date: 03/27/2009 12:29 PM Subject: Re: How to define alias in

Re: How to define alias in

2009-03-27 Thread Larry Meadors
1:03 AM, Jasmin Mehta > wrote: >> >> I can not change the column names of table QOL_DEPENDENT >> >> from FIRST_NAME to DEP_FIRST_NAME >> >> It has to be the same. >> >> >> From: Brandon Goodin >> To: >> user-java

Re: How to define alias in

2009-03-27 Thread Brandon Goodin
m FIRST_NAME to DEP_FIRST_NAME >> >> It has to be the same. >> >> >> From: Brandon Goodin To: >> user-java@ibatis.apache.org >> Date: 03/27/2009 11:59 AM Subject: Re: How to define alias in >> -- >> >> >>

Re: How to define alias in

2009-03-27 Thread Brandon Goodin
column names of table QOL_DEPENDENT > > from FIRST_NAME to DEP_FIRST_NAME > > It has to be the same. > > > From: Brandon Goodin To: > user-java@ibatis.apache.org > Date: 03/27/2009 11:59 AM Subject: Re: How to define alias in > ---

Re: How to define alias in

2009-03-27 Thread Larry Meadors
> user-java@ibatis.apache.org > Date: 03/27/2009 11:59 AM > Subject: Re: How to define alias in > > >              type="org.nexweb.qol.gcc.model.CustomerVO"/> > > >          >          >          >

Re: How to define alias in

2009-03-27 Thread Jasmin Mehta
I can not change the column names of table QOL_DEPENDENT from FIRST_NAME to DEP_FIRST_NAME It has to be the same. From: Brandon Goodin To: user-java@ibatis.apache.org Date: 03/27/2009 11:59 AM Subject: Re: How to define alias in

AW: How to define alias in

2009-03-27 Thread Benjamin Klatt
: Jasmin Mehta [mailto:jasmin_me...@nexweb.org] Gesendet: Freitag, 27. März 2009 17:52 An: user-java@ibatis.apache.org Betreff: How to define alias in Hi, With below code how do I get correct value for dependent first name and dependent last name? Right now as both qol_customer and

Re: How to define alias in

2009-03-27 Thread Brandon Goodin
SELECT cs.cust_status, cu.first_name, cu.middle_name, cu.last_name, dep.first_name as dep_first_name, dep.last_name as dep_last_name FROM qol_customer cu, qol_dependent dep

How to define alias in

2009-03-27 Thread Jasmin Mehta
Hi, With below code how do I get correct value for dependent first name and dependent last name? Right now as both qol_customer and qol_dependet has same field name for FIRST_NAME and LAST_NAME, I am getting qol_customer's FIRST_NAME and LAST_NAME populated in customerDependentVo.depFirstName