The list pulls starts another query and pulls in two values to compare to the original query values. The intention is to verify if the values from both queries equal each other to run again until they don't equal each other.
-----Original Message----- From: Michael E. Carluen [mailto:[EMAIL PROTECTED] Sent: Monday, September 17, 2007 4:36 PM To: CF-Talk Subject: RE: Loop based on if statement 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? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72&catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288640 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
