This is the who;e code which I had to do in order for it work <cfset currYear= Year(now())> <cfset currYear=int(currYear)> <cfoutput><cfset currYear=#currYear#></cfoutput>
<CFLOOP index="yearCnt" from='2000' to=#currYear#> <!---Query ----> </CFLOOP> And I do understand that every thing else listed on this post should work but only the above worked and am using CF8. NK >Try this: > ><CFLOOP index="yearCnt" from='2000' to='#currYear#'> > > >Right but something else is wrong. > >Azadi's example is about as simple as it gets. Something else in your code >is causing the problem. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324940 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4