I have seen it before, not sure why it happens but what I did
to solve it was set a temp variable to hold the first element of
the query and reset it when it changes.
cfset tempvar = ''
cfoutput query=myQuery
cfif tempvar NEQ myQuery.Value1
cfset tempvar = myQuery.Value1
/cfif
...
On each loop, whatever values you want to use in your inner loops need
to be set to a local variable in the loop.
In fact, been burned so many times now I just dont bother using the loop
count and alwasy set the variables I need straight after my cfloop
ie
cfloop query=qSomething
cfset
That's basically what the example variable in my demo code does - you
have to set it outside of the inner loop.
So is this a confirmed bug or anything?
I have seen it before, not sure why it happens but what I did
to solve it was set a temp variable to hold the first element of
the query and
-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 9:18 AM
To: CF-Talk
Subject: Re: Nested Query Loop Bug/Issue
That's basically what the example variable in my demo code does - you
have to set it outside of the inner loop.
So is this a confirmed bug or anything
Tony,
That's a known problem. To work around it, just set a local variable in the
outer loop equal to the value in Query1 you want to pass to Query2 and
access *that* variable inside of your inner loop.
~Dina
- Original Message -
From: Tony Schreiber [EMAIL PROTECTED]
To: CF-Talk [EMAIL
Thanks Dina, I know the work-around (It's in my original message and
used in my demo code) - I guess I was looking for how many people had run
into this before and if it was an official known-issue or not, or even
expceted behavior...
That's a known problem. To work around it, just set a local
i've had this problem before and arrived at the same solution as you. please fix this
mm.
alex
-Original Message-
From: Tony Schreiber [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 12:04 PM
To: CF-Talk
Subject: Nested Query Loop Bug/Issue
I don't know if any of you
I don't know if any of you have run into this before or if
it's even been mentioned (couldn't find it at mm technotes
either), but I've run into a situation where the values of an
outer loop referred to in an inner loop are not what you
expect. I was burned on this recently and remember
8 matches
Mail list logo