House of Fusion
Search over 2,500 ColdFusion resources here
  
Home of the ColdFusion Community

Mailing Lists
Home / Groups / ColdFusion Talk (CF-Talk)

Question about looping and the first row in a column

Author:
Andy Matthews
02/23/2007 11:42 AM

I'm sure that other people have run into this, but I'm baffled as to why this is happening. I have a query in the variables scope (VARIABLES.GetThisNavigationLocation). I'm looping over this query just like you would normally. Then, inside that loop, I'm looping over another query (VARIABLES.getChangeFrequencies) to build a dynamic dropdown. So for each row in GetThisNavigationLocation, there's a dropdown containing every row in getChangeFrequencies. The problem is that inside the dropdown loop, the cfif seems to be using the value from the very first row in the outer query in it's comparison which results in every dropdown showing the same value, even though when I dump the outer query, the values are clearly different. <cfloop query="VARIABLES.getChangeFrequencies"> <option value="#VARIABLES.getChangeFrequencies.ID#" <cfif VARIABLES.GetThisNavigationLocation.changefreq EQ VARIABLES.getChangeFrequencies.ID>selected</cfif>>#VARIABLES.getChangeFreque ncies.DisplayName#</option> </cfloop> The weird thing comes when I set a temp variable just outside the dropdown loop like so: <cfset tempFreq = VARIABLES.GetThisNavigationLocation.changefreq> When I use that code, and compare to "tempFreq", the code works just fine. Why is this happening? Does anyone have wisdom on this because it's really irritating for me to have to have this extra line of code in here. Anyone? ____________________________________ Andy Matthews Senior Coldfusion Developer Office:  877.707.5467 x747 Direct:  615.627.9747 Fax:  615.467.6249 amatthews@dealerskins.com www.dealerskins.com <http://www.dealerskins.com/>;


Search cf-talk

October 31, 2014

<<   <   Today   >   >>
Su Mo Tu We Th Fr Sa
       1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31   

Designer, Developer and mobile workflow conference