How would I keep column names unique in a query with a join where each table
has a like column name?
<cfset var optionValueGW =
getModelGlue().getORMService().createGateway("option_value") />
<cfset var query = optionValueGW.createQuery() />
<cfset query.innerjoin("option_value", "option_type", "option_type") />
<cfset order = query.getOrder() />
<cfset order.setAsc("option_type", "option_description") />
<cfdump var="#optionValueGW.getByQuery(query)#">
I get two columns called "active" and two columns called "option_type_id".
So, to rephrasing my question: How do I distinguish which table each column
belongs to in the query?
Thanks!
- Doug
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
