if that doesn't work, I'd recommend output'ing totalInfo.columnlist and see what's returned.
Bruce Dunwiddie Ticket Technology P: 866.543.3331 F: 913.451.7832 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hale, Frederick L, WCS Sent: Wednesday, January 07, 2004 1:18 PMSubject: RE: [KCFusion] Query of Queries Error Qualify it with the getInfo. Frederick Hale R.O.A.M. Support *Phone: 816-391-7745 * 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 To: [EMAIL PROTECTED] ColdFusion was unable to determine the value of the parameter. This problem is very likely due to the fact that either: 1. You have misspelled the parameter name, or 2. 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
<<attachment: winmail.dat>>
