Scott, Please clarify what you are working with; do you have a query with 2 fields (field1: query.id1 and field2: query.id2), and single list with multiple values ('id1', 'id2')? Is you intention to verify the existence of the values contained in either fields to the values of contained in the list?
Michael > -----Original Message----- > From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] > Sent: Monday, September 17, 2007 1:05 PM > To: CF-Talk > Subject: Loop based on if statement > > > I have a cfif that is run to verify results of a query vs list > <cfloop query="query"> > <cfif query.id1 EQ list.id1 OR query.id2 EQ list.id2> > > </cfif> > </cfloop> > What happens is that I need whats inside of this cfif to keep running > until > its false. I tried to put a conditional cfloop around this > > <cfset myvalue = 0> > <cfloop> > <cfif query.id1 EQ list.id1 OR query.id2 EQ list.id2> > <cfloop condition="myvalue EQ 0"> > <run generation> > <cfif query.id1 EQ list.id1 OR query.id2 EQ list.id2> > <cfset myvalue = 1> > <cfelse> > <cfset myvalue =0> > </cfif> > </cfloop> > </cfif> > <cfset myvalue=0> > </cfloop> > > This still isn't working.. if I output what myvalue is set to alot of the > rows show a value of 1 as if its not running until the condition is 0. > What > am I missing? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288635 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4