duh ... thanks Jon,
I was going crazy ... and it's so straightforward (when you know what you're doing) thx again Gil Midonnet -----Original Message----- From: jon hall [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:54 PM To: CF-Talk Subject: Re: Reindex field: WAS order and re-oder 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:137622 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm