You can use the MAXROWS attribute on CFQUERY and/or on CFOUTPUT.  

That should do it,
Lee.


-----Original Message-----
From: Michael Gribbin [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 20 March 2001 14:10
To: CF-Talk
Subject: One record query output


Hi, I'm trying to find out if it's possible to limit the output of a query
to one record. 

....


IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee.  It is confidential and may contain legally privileged
information.  No confidentiality or privilege is waived or lost by any
mistaken transmission to you.  If you receive this e-mail in error, please
immediately delete it from your system and notify the sender.  You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient.  The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.  

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to