> 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 v
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
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 v
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" <
-
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
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
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
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.
...
>>> [EMAIL PROTECTED] 03/27/03 12:04PM >>>
I don't know if any of you have run into this before or if it's eve
8 matches
Mail list logo
