I just noticed the loop index variable is wrong, I changed it to from "i" to
"region" as it should be and still got the same error message...
-----Original Message-----
From: Kevin Gilchrist
Sent: Thursday, May 31, 2001 11:32 AM
To: CF-Talk (E-mail)
Subject: Is it possible to nest CFQUERY inside CFLOOP?
I get an error when I try to do this:
<cfloop index="region" list="lst_region">
<cfquery name="qry_Full_Week_Downtime_Region#i#" datasource="#DSN#"
dbtype="Oracle80" cachedwithin="#CreateTimeSpan(0,1, 0, 0)#">
SELECT
sum(severity_minutes) as sev_sum,
max(total_minutes)
FROM
history_view,
site_name
WHERE
query_id =259 AND
node='RS_CHARMING1' AND
severity=5 AND
customer_name='CHARMING' AND
application='RS_PING' AND
region=#i#
</cfquery>
</cfloop>
The error message is:
Just in time compilation error
A nested CFQUERY tag has been encountered at document position (455:2) to
(455:130). CFQuery tags cannot be nested inside one another.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
