this should work if i understand what you are trying to do: <!--- set start to id divided by 10, rounded down to nearest integer. Multiply by ten and add one ---> <cfset start = (int(url.video_id/10) * 10) + 1>
<!--- set end to id divided by 10 and rounded up, multiply by 10 ---> <Cfset end = ceiling(url.video_id/10) * 10> On 8/25/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > I want to loop over a URL.VIDEO_ID value and find the numeric range it > falls in. > The value range needs to be between 1-10 or 11-21 etc. until the condition > is met. > > EXAMPLE: if the URL.VIDEO_ID value is 72 I would want to cfloop until I > found the range that this 72 value fit and then set variables like ... > <CFSET start = 71> > and > <CFSET end = 80> > > I have ... > > <CFSET START = 1> > <CFSET END = 10> > > THIS IS WHERE I NEED HELP > > <CFLOOP condition="URL.VIDEO_ID GREATER THAN OR EQUAL TO START OR > URL.VIDEO_ID LESS THAN OR EQUAL TO END" step="10"> > ???? > </CFLOOP> > > D- > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:251008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4