>> Did you have a problem with timeouts or out of memory errors? >> >> I have quite a bit of records > >You have a couple of options. > >First, you could simply increase the timeout for the script using the >appropriate CF command. ><cfsetting enabletimeout="some larger number goes here"> > >Second, you could write a paging mechanism to only do this with n >records, then invoke the script again for the next n after the first >iteration has completed. > >Third, you could rewrite the whole thing as a stored procedure. >Updating each record individually from CF is the least-efficient way >to make a global change to your database. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >http://training.figleaf.com/ > >Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on >GSA Schedule, and provides the highest caliber vendor-authorized >instruction at our training centers, online, or onsite.
Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:354909 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm