Select out the fields to be reindexed, order by the sort order field. <cfloop query="qryName"> <cfquery...> UPDATE Table SET SortOrder = #qryName.currentRow# WHERE SortOrder = #qryName.SortOrder# </cfquery> </cfloop>
-- jon mailto:[EMAIL PROTECTED] Thursday, September 18, 2003, 3:32:28 PM, you wrote: m> Ok, I've been looking and need some pointers -- m> how does one reindex a field whose records are (for example) m> 1 m> 34 m> 56 m> 58 m> 112 m> and make it m> 1 m> 2 m> 3 m> 4 m> 5 m> I'll be using either access of mysql m> Gilbert Midonnet m> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm?link=i:4:137585 Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
