Rick, you are aware that using that UDF requires you to select your entire table out of the database and into CF's memory so you can call the UDF, right? Suitable for some applications, but by and large, having the DB to the work is a much better route to go.
cheers, barneyb On Wed, 02 Feb 2005 23:44:28 -0500, Rick Root <[EMAIL PROTECTED]> wrote: > Duncan I Loxton wrote: > > > > I need to get one row and one row only from a sql table - cheesy > > quotes for our corporate intranet..... > > cflib is your friend > > http://www.cflib.org/udf.cfm?ID=524 > > This UDF works fabulously. > > QueryRandomRows(theQuery, NumberOfRows) > Author: Shawn Seley and John King (Send Email) > Library/Category: DataManipulationLib/Query > Required CF Version: ColdFusion 5 > Version: 1 > Last Updated: July 10, 2002 > Rating: Not Yet Rated > > Description > Returns a query object with a specified number of random records from > the passed query. Some code based on QuerySlice() by Kevin Bridges > ([EMAIL PROTECTED]) > > Please note that results below will not be random due to caching at > cflib.org. > -- Barney Boisvert [EMAIL PROTECTED] 360.319.6145 http://www.barneyb.com/ Got Gmail? I have 50 invites. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192850 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
