#query.column[row]#
EX. #getItem.ItemName[itemtodisplay]# #getItem.ItemDescription[itemtodisplay]#
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-----Original Message-----
From: Angel Stewart [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 12:21 PM
To: CF-Talk
Subject: Selecting a specific row from the cfquery?
I'm trying to randomly bring back a specific row from a query recordset.
How do I do that? I can't figure it out. :-\
The query is "GetItem" and I'm using
<CFSET itemtodisplay = #RandRange(1,#getitem.recordcount#)#>
So I need to display the #itemtodisplay# row of the query.
Been looking through CFWACK but I haven't been able to figure how to
pull a specific row from a recordset but I just don't see that.
I know that queryname.currentrow displays the current row being output.
But how do I specifically pull a row?
-Gel
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.559 / Virus Database: 351 - Release Date: 1/7/2004
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
