If your Query contains many records and you only need to display a few. I have a database with about 3000+ users I want to display the info for the last 20 that have signed up.
Rick -----Original Message----- From: Tyler Silcox [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 02, 2002 5:32 PM To: CF-Talk Subject: SELECT TOP n vs MaxRows... A quickie: Is there any benefit to using SELECT TOP n vs using the MaxRows attribute in cfquery? Tyler Silcox email | [EMAIL PROTECTED] ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
