note that for consistency (especially across RDBMS Platforms), you should use the ORDER BY clause when using SELECT TOP blah....
~Simon Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -----Original Message----- From: Raymond Camden [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 29, 2001 9:37 AM To: CF-Talk Subject: RE: maxrows question All the records are returned by the DB. So, if you can use SQL instead of MAXROWs, it would probably be marginally better performance wise. For example, if you want the first X records, I know SQL Server lets you do: SELECT TOP 10 Foo, Goo, YourBoots FROM .... ======================================================================= Raymond Camden, Principal Spectra Compliance Engineer for Macromedia Email : [EMAIL PROTECTED] Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] > Sent: Thursday, November 29, 2001 9:31 AM > To: CF-Talk > Subject: maxrows question > > > Does anyone know if i set a maxrow value of 1 in a select query, > if just one record is passed to coldfusion by the database or > all matching results are returned by the database but only one is made > available? > > > Kola Oyedeji |Web Developer |ekeda > elthorne gate |64 high street |pinner |middx |ha55qa > t +44(208)429 7333 f +44(208)429 7339 |www.ekeda.co.uk > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists