Nested Query Loop Bug/Issue

2003-03-27 Thread Tony Schreiber
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 vaguely it

Re: Nested Query Loop Bug/Issue

2003-03-27 Thread Randell B Adkins
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 ...

RE: Nested Query Loop Bug/Issue

2003-03-27 Thread David Collie (itndac)
and prefer looking elsewhere This could be described as a FEATURE of cold fusionhehehehe -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED] Sent: 27 March 2003 17:04 To: CF-Talk Subject: Nested Query Loop Bug/Issue I don't know if any of you have run into this before

Re: Nested Query Loop Bug/Issue

2003-03-27 Thread Tony Schreiber
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

RE: Nested Query Loop Bug/Issue

2003-03-27 Thread James Ang
- 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

Re: Nested Query Loop Bug/Issue

2003-03-27 Thread Dina Hess
PROTECTED] Sent: Thursday, March 27, 2003 11:04 AM Subject: Nested Query Loop Bug/Issue 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

Re: Nested Query Loop Bug/Issue

2003-03-27 Thread Tony Schreiber
: Nested Query Loop Bug/Issue 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

RE: Nested Query Loop Bug/Issue

2003-03-27 Thread Sicular, Alexander
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

RE: Nested Query Loop Bug/Issue

2003-03-27 Thread Philip Arnold
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