Thanks guys I was actuall trying to work out the most efficient way to determine if a key exists in the db and then do some processing if it does, without searhing the rest of the records. I'm thinking that using Exists would be more efficient.
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 > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: 29 November 2001 14:37 > 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 > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
