<cfquery name="myquery" datasource="odbc">
SELECT
*
FROM TABLE
</cfquery>
<cfoutput>
#myquery.myfield[5]#
</cfoutput>
James Wu
-----Original Message-----
From: Alford, Gary
[mailto:[EMAIL PROTECTED]]
Sent: Monday, October 15,
2001 12:40 PM
To: '[EMAIL PROTECTED]'
Subject: RE:
SQL
<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]
============================================
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
|
