You have an unterminated CFQUERY in your page though you have only pasted a
snippet of the code into your email. Take a look above your code and try to
find the offending tag.
> -----Original Message-----
> From: Kevin Gilchrist [mailto:[EMAIL PROTECTED]]
> Sent: 31 May 2001 16:38
> To: CF-Talk
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
