----- Original Message -----
Sent: Wednesday, January 07, 2004 1:33
PM
Subject: RE: [KCFusion] Query of Queries
Error
Actually, I believe you should use qualify it with totalinfo, not
getinfo to get the correct output.
Eddie McReynolds
Architecture Software Analyst
Clinical Reference Laboratory
Voice: (913) 693-2512
(800) 445-6917 Ext.: 2512
Fax: (913) 492-4316
Email: [EMAIL PROTECTED]
OUR VALUES &
CULTURE
* Service to
Humanity * Flexibility * Commitment * Compassion * Teamwork *
* Perseverance *
Quality * Integrity * Client Focus *
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 -----
Sent: Wednesday, January 07, 2004
1:18 PM
Subject: RE: [KCFusion] Query of
Queries Error
Qualify it with the getInfo.
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
DISCLAIMER: The information in this message is
confidential and may be legally privileged. It is intended solely for the
addressee. Access to this message by anyone else is unauthorized. If you are
not the intended recipient, any disclosure, copying, or distribution of the
message, or any action or omission taken by you in reliance on it, is
prohibited and may be unlawful. Please immediately contact the sender if you
have received this message in error. Thank
you.
