Re: [KCFusion] Query of Queries Error

[Adaryl Wakefield]

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

OK thats different. The example I was looking at did not have an example of how to output. Just for s and gs why don't you qualify it with the name of the query that combines the recordsets?   Adaryl "Did you reboot?" Wakefield Aviator by passion Programmer by sheer force of will ----- Original Message ----- From: Hale, Frederick L, WCS To: [EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:18 PM Subject: RE: [KCFusion] Query of Queries Error Qualify it with the getInfo.   Frederick Hale R.O.A.M. Support (Phone:  816-391-7745 4 Fax:      816-391-5027 -E-Mail: [EMAIL PROTECTED] -----Original Message----- From: Adaryl Wakefield [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004 1:19 PM To: [EMAIL PROTECTED] Subject: [KCFusion] Query of Queries Error 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