Can anyone confirm that this is how it is supposdto work?
Actually, this is how it does work.
IMO it is for the least a serious flaw in the design. There is no reason
the current row
should be implicit for the most inner level of the loop only.
--
___
REUSE
I was doing a
cfloop query=outerQuery
cfloop query=innerQuery
cfoutput#outerfieldvalue# #innerfieldvalue#/cfoutput
/cfloop
/cfloop
outerfieldvalue is a fieldname unique to the outer query, however when I do the
loop, for all outerloop iterations, I noticed it brought only the first row
Srinivasa Teja Palla wrote:
I was doing a
cfloop query=outerQuery
cfloop query=innerQuery
cfoutput#outerfieldvalue# #innerfieldvalue#/cfoutput
/cfloop
/cfloop
outerfieldvalue is a fieldname unique to the outer query, however when I do
the loop, for all outerloop iterations, I noticed it
Jeff D. Chastain wrote:
I was referring to the inner query using the full scoped name -
variables.queryName.
So, why does setting newQueryName = variables.queryName PRIOR to looping
the first query change anything? Both variables are in the variable
scope and are created prior to the first
is null. For some reason the variable is just gone.
Thanks
-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 8:23 AM
To: CF-Talk
Subject: Re: Nested Query Loops
Jeff D. Chastain wrote:
I was referring to the inner query using the full scoped
Jeff D. Chastain wrote:
I am not even making it that far. I am getting an error on cfloop
query=qry2 stating that qry2 is not a recordset. If I do a cfdump
prior to the first loop, qry2 is a recordset with several rows of data.
If I do a cfdump right before the second loop (i.e. inside the
Nope, all names (query and column) are different between the two
queries.
-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 04, 2002 9:21 AM
To: CF-Talk
Subject: Re: Nested Query Loops
Jeff D. Chastain wrote:
I am not even making it that far. I
-vancouverisland.com
- Original Message -
From: Jeff D. Chastain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 3:25 PM
Subject: RE: Nested Query Loops
Okay, what do you mean by properly referencing the
queries?
I always use the queryname.columnname inside of a
loop
I have got a situation where I need to dynamically generate a form with
one section of the form being duplicated for every set of values in a
query. Within each duplicated section of the form, there is a list of
items generated by a second query. The result, I have a cfloop for the
first query,
Not sure this is the problem, but I've had problems with nesting loops, forgetting
that you need to set a variable from the outer loop (with a new name) before using
that variable in the inner loop. I don't understand why, but variables get confused in
nested loops. This *might* have something
be the same
right?
BTW - copying the query over to a new name worked. Now the question is
why?
Thanks
-Original Message-
From: Keith Dodd [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 3:17 PM
To: CF-Talk
Subject: Nested Query Loops
Not sure this is the problem, but I've had
]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 2:30 PM
Subject: RE: Nested Query Loops
I was referring to the inner query using the full scoped name -
variables.queryName.
So, why does setting newQueryName = variables.queryName PRIOR to looping
the first query change anything
Ticket
application.
- Original Message -
From: Jeff D. Chastain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 2:30 PM
Subject: RE: Nested Query Loops
I was referring to the inner query using the full scoped name -
variables.queryName.
So, why does
.
-- Jeff
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 4:34 PM
To: CF-Talk
Subject: Re: Nested Query Loops
Well...think about your nested loop having fieldnames that same as the
outer loop
CF has to know which field you
I don't know why this oddity. But do know that I've posted similar questions when
nested queries weren't working, and someone would always remind me of this need. Don't
think anyone ever had a reason though. :)
Keith
~|
- Original Message -
From: Jeff D. Chastain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 2:39 PM
Subject: RE: Nested Query Loops
I can see that ... The issue is that I have two differently named
queries with differently named columns. The CF error
-Original Message-
From: Bryan Stevenson
[mailto:[EMAIL PROTECTED]]
Sent: Monday, December 02, 2002 4:45 PM
To: CF-Talk
Subject: Re: Nested Query Loops
I beleive this is the case ALWAYS even if the 2 queries
have seperate names
and fields. This feature is there to prevent the
issue I mentioned
- Original Message -
From: Jeff D. Chastain [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, December 02, 2002 3:25 PM
Subject: RE: Nested Query Loops
Okay, what do you mean by properly referencing the
queries?
I always use the queryname.columnname inside of a loop,
even
18 matches
Mail list logo