I would assume you would get all requests back.... Maybe you could use the Top sql command to ensure that only one record is delt with....
HTH -----Original Message----- From: Kola Oyedeji [mailto:[EMAIL PROTECTED]] Sent: 29 November 2001 14:31 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
