I had just written a quick function that did this for me in my Gateways (or
in a component the Gateways extend):
<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>
On Jan 18, 2008 6:57 AM, Doug Hughes <[EMAIL PROTECTED]> wrote:
> I suppose I don't change table names that frequently. :)
>
> On 1/18/08, Tom Chiverton <[EMAIL PROTECTED] > wrote:
>
> > On Friday 18 Jan 2008, Doug Hughes wrote:
> > > With regards to your suggestions, why don't you just write your query
> > out?
> > > Wouldn't you know your table names before you write your SQL?
> >
> > If the table or field names change, I'd have to edit both reactor.xmland the
> > Gateway, with the way I suggest, the Gateway would notice automagically.
> >
> >
> > --
> > Tom Chiverton
> > Helping to continuously utilize transparent IPOs
> > on: http://thefalken.livejournal.com
> >
> > ****************************************************
> >
> > This email is sent for and on behalf of Halliwells LLP.
> >
> > Halliwells LLP is a limited liability partnership registered in England
> > and Wales under registered number OC307980 whose registered office address
> > is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3
> > 3EB. A list of members is available for inspection at the registered
> > office. Any reference to a partner in relation to Halliwells LLP means a
> > member of Halliwells LLP. Regulated by The Solicitors Regulation Authority.
> >
> >
> > CONFIDENTIALITY
> >
> > This email is intended only for the use of the addressee named above and
> > may be confidential or legally privileged. If you are not the addressee you
> > must not read it and must not use any information contained in nor copy it
> > nor inform any person other than Halliwells LLP or the addressee of its
> > existence or contents. If you have received this email in error please
> > delete it and notify Halliwells LLP IT Department on 0870 365 2500.
> >
> > For more information about Halliwells LLP visit www.halliwells.com.
> >
> >
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > -- -- --
> > Reactor for ColdFusion Mailing List
> > [EMAIL PROTECTED]
> > Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> > -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> > -- -- --
> >
> >
>
>
> --
> Doug Hughes, President
> Alagad Inc.
> [EMAIL PROTECTED]
> 888 Alagad4 (x3)
> Office: 919-550-0755
> Fax: 888-248-7836
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
> Reactor for ColdFusion Mailing List
> [EMAIL PROTECTED]
> Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
> -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
> -- --
>
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Reactor for ColdFusion Mailing List
[EMAIL PROTECTED]
Archives at: http://www.mail-archive.com/reactor%40doughughes.net/
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
