RE: SQL

[Alford, Gary]

Yes, you are correct.  My mistake.  I was thinking of <cfloop.. instead of <cfquery...   ============================================ Gary L. Alford Supplier Product Assurance Bell Helicopter Textron Phone: (817) 280-6233 Fax: (817) 278-6233 mailto:[EMAIL PROTECTED] ============================================ -----Original Message----- From: Karen Harker [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 12:47 PM To: Alford, Gary; [EMAIL PROTECTED] Subject: RE: SQL That should be maxrows="1", shouldn't it?   Karen >>> [EMAIL PROTECTED] 10/15/01 12:40:24 PM >>> <cfquery name="myquery" datasource="odbc">     SELECT    *     FROM    TABLE </cfquery>   <cfoutput query="myquery" startrow="5" maxrows="5">     ... </cfoutput>   ============================================ Gary L. Alford Supplier Product Assurance Bell Helicopter Textron Phone: (817) 280-6233 Fax: (817) 278-6233 mailto:[EMAIL PROTECTED] ============================================ -----Original Message----- From: Gregory Price [mailto:[EMAIL PROTECTED]] Sent: Monday, October 15, 2001 12:29 PM To: [EMAIL PROTECTED] Subject: OT: SQL does anyone know how to get a single row in a select statement in sql say I want to grab the 5th row in some table regardless of its contense, i just want the 5th record any help is appreciated! Thanks Greg Price