Hi Larry: I wasn't going to use column indexes (fragile) but this solution is perfect.
Thanks. parki... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Meadors Sent: Wednesday, December 05, 2007 11:06 PM To: [email protected] Subject: Re: A couple newbie questions In my experience, column indexes are kind of fragile - I prefer to alias the fields like this: select customer.name as "customerName", product.name as "productName" from.... Larry On Dec 5, 2007 3:54 PM, Jeff Butler <[EMAIL PROTECTED]> wrote: > It's not magic, but you could also use columnIndex in your result map > instead of column - then you wouldn't need to do any renaming in the SQL > statement. > > Jeff Butler
