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 <moniqueb...@gmail.com>wrote: > > >Hi All. > > > >Is there a way for me to retrieve records from a db in groups? > > > >I have a query that selects over 200,000 records and it times out on the > cf output. > > > >Thanks > > I don't think I asked this right. What I need to do is encrypt user > passwords I need to do it in CF. Problem is there are over 200,00 records > which is too much for the cf loop and output. > > Any suggestions? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:345404 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm