The cfoutput inside a cfloop is unnecessary to resolve the variables within
the cfquery block. I use cfquery inside cfloop all the time to do any
number of different things. There is something else going on with the code
if it is not working.
DC
----- Original Message -----
From: "Bill Davidson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 13:05
Subject: Re: Is it possible to nest CFQUERY inside CFLOOP?
> You should be able to nest cfquery in a cfloop that is not query based...
> Maybe the actual problem is that cfloop doesn't implicitly force a
cfoutput,
> so chances are your variables are not getting resolved. Include a
> <cfoutput> inside the loop.
>
> Here's a code snippet where I am nesting a query inside a loop:
> <cfloop index="loop_index" from="1" to="#ArrayLen(jobs_time_spent)#">
> <cfoutput>
>
> <CFQUERY name="qry_job_rate" datasource="#application.dsn#">
>
> SELECT dbo.Jobs.Jobs_Job_Name, dbo.Employee_Job_Rates.*
> FROM {oj dbo.Jobs LEFT OUTER JOIN dbo.Employee_Job_Rates ON
> dbo.Jobs.Jobs_ID = dbo.Employee_Job_Rates.Employee_job_rates_job_id }
> where Employee_job_rates_employee_id = #attributes.user_id#
> and dbo.Jobs.Jobs_Job_Name = '#jobs_names[loop_index]#'
>
> </CFQUERY>
> .....
> </cfoutput>
> </cfloop>
>
> The only other thing I could think of is the list attribute for cfloop.
> Maybe cold fusion internally handles lists as a query. Maybe just do a
> "from to" loop and only do the query and related code when the index is in
> the list. That's what I am doing in the previous block of code, except
with
> arrays.
>
> HTH,
> -Bill
> www.brainbox.tv
>
> ----- 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
