I had to alias (self-join) a table:
<cfquery name="Query1" datasource="xxx">
select ap.cs_caseidd, bb.cs_caseidd, ap.c_number
from
case ap, case bb
where ...
</cfquery>
I'm trying to place the record(s) into a table:
<td>#Query1.ap.c_number#</td>
<td>#Query1.bb.cs_caseidd#</td>
...
However, I'm getting a error. The error states "ap.c_number is undefined in Query1"
What is the proper sytax for obtaining the record in the output in this particular situation?
Thank you for your help.
Jeremy
<cfquery name="Query1" datasource="xxx">
select ap.cs_caseidd, bb.cs_caseidd, ap.c_number
from
case ap, case bb
where ...
</cfquery>
I'm trying to place the record(s) into a table:
<td>#Query1.ap.c_number#</td>
<td>#Query1.bb.cs_caseidd#</td>
...
However, I'm getting a error. The error states "ap.c_number is undefined in Query1"
What is the proper sytax for obtaining the record in the output in this particular situation?
Thank you for your help.
Jeremy