[KCFusion] Query of Queries Error

[Adaryl Wakefield]

Title: Re: [KCFusion] Cold Fusion Web Developer/Programmer Position

I have this   <cfquery name="getLogs" datasource="intranet"> SELECT memberID, timeIn, timeOut, reason FROM table1 WHERE dateID = (SELECT MAX(dateID) AS dateID FROM table2) </cfquery> <cfquery name="getInfo" datasource="loginsMaster"> SELECT firstName, lastName, memberID FROM table3 ORDER BY lastName </cfquery> <cfquery name="totalInfo" dbtype="query"> SELECT getInfo.firstName, getInfo.lastName, getLogs.timeIN, getLogs.timeOut, getLogs.reason FROM getLogs, getInfo WHERE getInfo.memberID = getLogs.memberID </cfquery>    and   <tr>    <cfoutput query="totalInfo">    <td>#firstName#</td>    <td>#lastName#</td>    <td>#timeOut#</td>    <td>#timeIn#</td>    <td>#reason#</td>    </cfoutput>   </tr>   and get this Error resolving parameter FIRSTNAME ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: You have misspelled the parameter name, or You have not specified a QUERY attribute for a CFOUTPUT, CFMAIL, or CFTABLE tag. What on earth?     Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will