how do you randomly select a something from a table

[dunskii]

Hi again,

how do you randomly select something from a table. eg. table id

thanks again,

Dunskii

 

[Sarky78]

the way that i usually get a random record from a database is to run a query, to get all of the records from the database and then use randrange. this generates a number between a two numbers

I would use the following code:

<CFSET List = &quot;&quot;>
<CFLOOP query=&quot;queryname&quot;>
<CFSET List = #ListAppend(List,DatabaseID)#>
</CFLOOP>

<CFIF queryname.Recordcount GT 0>
<CFSET randRec = RandRange(1,ListLen(List))>
</CFIF>

then to output the information:
<cfoutput>
#queryname.fieldname[randRec]#
</cfoutput>

the use of the list is required so that we don't get a random number for a database record that doesn't exist.

hope this helps!