yeah i think your right, thanks, i will def post if i see the problem again
thanks again for your advice >Chances are it was your code rather than cfloop being broken. > >Post up some code and we might stop the problem. > >Adrian > >hi, > >i have noticed on a couple of occasions when i use the cfloop query that it >sometimes doesn't loop it correctly, and sometimes skips records. > >rather than looking into this in the past i started changing the loops to >use an index instead. but now i would like to use the cfloop query as it >does look better and was wondering if you guys have ever experienced >anything like this. > >if not then i will start to use them again and if i reach the problem then i >can look into more > >appreciate your input > >richard ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312504 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

