the
best thing would probably be to use the aliasing in the query as opposed to
renaming the column in the table like this...
select
parentTable.state as parent_state, childTable.state as child_state from
parentTable, childTable where something = something
then
you can use
I
would just use an alias when calling the field name using the AS
keyword.
Misty
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Adaryl
WakefieldSent: Tuesday, January 28, 2003 4:01 PMTo:
[EMAIL PROTECTED]Subject: [KCFusion] same field
Change the way you write your select statement
Select parentTable.state as parentstate, childTable.state as childstate
where x = y, etc. etc.
cfoutput
I am outputting the value of the parent table #queryName.parentState# and
now the child #queryName.childstate.
/cfoutput
The trick is using