put pound signs around 1st_region. The string "1st_region" is not a list,
but "#1st_region#" probably is.
Bryan Love ACP
Internet Application Developer
[EMAIL PROTECTED]
-----Original Message-----
From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 31, 2001 8:36 AM
To: CF-Talk
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