query row random access

[krisplus5]

Is there a way to retrieve data from a specific row or a query recordset--rather than looping through the recordset. Something like queryname.getdata(17,3) where the 17,3 represent row and column numbers. I haven't been able to find anything in the documentation or myriad books we have.

Thanks,
Kris

 

[tleish]

Yes, you can reference the query as if it were an array of structures. Structures being the column names and arrays being the rows.

Table Named: User

userID | userName
----------------------
42 | jane
56 | joey
99 | matt
104 | cindy

<CFQUERY NAME=&quot;qUsers&quot;>
SELECT * FROM User
ORDER BY userID
</CFQUERY>

<CFOUTPUT>
#qUsers.userName

[

2

]

#[COLOR=000080]<BR>[/color] [COLOR=666666]<!--- joey --->[/color]
#qUsers.userName

[

1

]

#[COLOR=000080]<BR>[/color] [COLOR=666666]<!--- jane --->[/color]
#qUsers.userName

[

4

]

#[COLOR=000080]<BR>[/color] [COLOR=666666]<!--- cindy --->[/color]
#qUsers.userName

[

3

]

#[COLOR=000080]<BR>[/color] [COLOR=666666]<!--- matt --->[/color]
</CFOUTPUT> - tleish

 

[krisplus5]

Excellent! Thanks much.
Kris