How can I get particular Row in a query variable using ColdFusion?

Question

Take the following query example:

<cfquery name="Test" Datasource = "TestDB">
    Select * from Table_Test
</cfquery>

Assume that the "Test" query returns 10 rows. I want to show single row on current time.

Note: I do not want to change the SQL statement.

The sentence, "I want to show single row on current time.", is not clear. — Dan Bracuk, Oct 27 '14 at 12:28
I second what @DanBracuk says. I think CFML_Developer has answered your question, but that's predicated on guessing what you mean in that highlighted sentence. — Adam Cameron, Oct 27 '14 at 12:45

score 7 · Answer 1 · edited Oct 27 '14 at 13:25

7

If you know your row number, Test.columnName[RowNumber] will show you the value of the columnName in specified row number.

edited Oct 27 '14 at 13:25

Community

answered Oct 27 '14 at 12:18

CFML_Developer

Yes brother you are right.But the table has minimum 50 column any way Thank you for answering this question. – Mohanrajan Oct 27 '14 at 15:16

score 3 · Accepted Answer · edited May 23 '17 at 12:27

3

If you want one random row from the query:

    <cfset start = randRange(1, Test.recordCount)>
    <cfoutput>
        #Test.name[start]#&nbsp;#Test.email[start]#<br>
    </cfoutput>

No need to loop.

NOTE: It is more efficient to modify the query to get a random row.

edited May 23 '17 at 12:27

Community

answered Oct 27 '14 at 21:05

Scott Jibben

I'm not sure how you deduced that he wanted a random row, but kudos on taking that away from this question! – J.T. Oct 28 '14 at 13:39
1

He had answered his question and it looked like that was what he was trying to do. That answer has been removed so it now looks like I can read minds. ;) – Scott Jibben Oct 29 '14 at 15:40

2 Answers2