[Reactor For CF] Re: Determine table names in custom query?

[Brian Kotek]

OK well I was able to track it down like this, but is there an easier way?

#_getConfig().getObjectConfig('schedule').object.xmlAttributes.name#

I'd think something like this in a custom query would be very common, so if there isn't an easier way perhaps something like:

<cffunction name="getTableName" access="private" returntype="string" output="false" hint="I return the table name for the passed table alias.">
    <cfargument name="tableAlias" type="string" required="true" hint="Alias of target table." />
    <cfreturn _getConfig().getObjectConfig(arguments.tableAlias).object.xmlAttributes.name />
</cffunction>

thx

Brian

On 4/12/06, Brian Kotek <[EMAIL PROTECTED]> wrote:

Folks, when writing a custom query in your DAO or Gateway, is there a way to get the table name for a given alias that you set up in the Reactor config file?

In other words...

<cffunction name="myCustomGatewayMethod">
select *
from [some method call to give me the table name for my alias here]
</cffunction>

perhaps like (even though I know this won't actually work):

<cffunction name="myCustomGatewayMethod">
select *
from #getConfig().getTable('myAlias')#
</cffunction>

thanks.

-- Reactor for ColdFusion Mailing List -- reactor@doughughes.net -- Archives at http://www.mail-archive.com/reactor%40doughughes.net/