Don't know what your problem is, but it is definitely OK to have cfquery
inside cfloop. Do you perchance have improperly closed prior cfquery?? (My
usual trick is to dup the <cfquery> and forget to put the "/" in ) :)
----- Original Message -----
From: "Kevin Gilchrist" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 11:38 AM
Subject: FW: Is it possible to nest CFQUERY inside CFLOOP?
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
