MS SQL has the TOP parameter. Use it like: SELECT TOP 20, fieldname, etc.... this will be the same as Limit 20.
Kind Regards, Nitai On Mon, Mar 21, 2011 at 10:44 PM, Jason King <[email protected]> wrote: > I'm using MS-SQL, and there's no 'limit' function. So at this point I'm > using CFQUERY's maxrows to limit the results. However, I believe that the > query is still grabbing more than 20 rows (being that I want 20 random ads), > it's just that it's being limited to 20 AFTER the query has run. -- See for yourself how easy it is to manage files today. Join the revolution! Razuna SaaS On-Demand - Hosted Digital Asset Management Solution http://www.razuna.com/ Razuna - Open Source Digital Asset Management http://www.razuna.org/ Follow us on Twitter http://twitter.com/razunahq -- official tag/function reference: http://openbd.org/manual/ mailing list - http://groups.google.com/group/openbd?hl=en
