SELECT TOP 100000 ... ORDER BY [reverse order of first 100000] or
<cfoutput startrow="100000"> or <cfloop startrow="100000"> On Mon, Jun 20, 2011 at 8:31 AM, Torrent Girl <[email protected]> wrote: > > >SELECT TOP 100000 ... > > > >or > > > ><cfoutput startrow="1" maxrows="100000"> > > > >or > > > ><cfloop startrow="1" endrow="100000"> > > > >On Fri, Jun 17, 2011 at 12:57 PM, Torrent Girl <[email protected] > >wrote: > > > >> > > Thanks but what about the next 100000. I need to update all of the records. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:345429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
