Couldn't you just 'AS' your column names in your select statements? Then you'd only have to maintain the sql.
________________________________ From: Milivoj Milani [mailto:[EMAIL PROTECTED] Sent: Monday, September 22, 2008 3:37 AM To: [email protected] Subject: RE: Alias to column names? I doubt it, I don't think you can do that. ________________________________ From: Basem Emara [mailto:[EMAIL PROTECTED] Sent: Saturday, September 20, 2008 2:27 PM To: [email protected] Subject: Alias to column names? Is there a way to give alias names to column names? I'd really like to define the column name aliases at the top of XML file, then use those alias names in parameter maps and inline result maps. It's a real pain when database field name changes (or db migration) when I have to dig thru all the inlines and maps. This way, I can just change the alias section at the top. Can this be done? Confidentiality Notice: This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this e-mail is strictly prohibited. If you have received this e-mail transmission in error, please reply to the sender, so that arrangements can be made for proper delivery, and then please delete the message from your inbox. Confidentiality Notice: This e-mail transmission may contain confidential or legally privileged information that is intended only for the individual or entity named in the e-mail address. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or reliance upon the contents of this e-mail is strictly prohibited. If you have received this e-mail transmission in error, please reply to the sender, so that arrangements can be made for proper delivery, and then please delete the message from your inbox.
