Yeah I am using that now, but the connection to the database is across the internet using a VPN. The less bandwidth necessary the better. I've always been under the assumption that the entire recordset is returned to CF, no matter what you put in maxrows...so the recordset may look the same, but it doesn't work the same.
jon ----- Original Message ----- From: "Ben Johnson" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, July 11, 2002 5:10 PM Subject: RE: Sybase TOP equivalent? > > Is there an equivalent to SQL Server TOP command in Sybase? > > I'm not sure if you're using <cfquery> for this or if it's a general > question, but <cfquery> has a MAXROWS attribute you can set and that'll work > the same. > > > > Ben Johnson > > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
