hehehe
can always count on Dave for good news ;)
jeff
-----Original Message-----
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 23, 2001 4:02 PM
To: CF-Talk
Subject: RE: Call a specific record in a query??
> How would I call a specific row in a query.
>
> example of what I want to do:
>
> <cfquery name="myQuery" Datasource="#DSN#">
> SELECT myField1, myField2
> FROM myTable
> </cfquery>
>
> <cfoutput>
>
> I want to display the 3rd record in my query<br>
> I assume I would do something like this<br>
> #myQuery.myField1[3]#<br>
>
> </cfoutput>
Your assumption is correct.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
