Viewing: Random Query

cf_randomquery is a quick solution to give a random recordset.
This custom tag supports any kind of query (recordset) as the datasource, not limited to specific database.

Requirements: ColdFusion 5, MX and up

Usage:


Examples:
1. Randomize recordset from database query.


SELECT PARKNAME, REGION, STATE
FROM Parks




2. Randomize recordset from programmatically created query











Important Note:
This custom tag adds one column name "cf_randomquery" to the resulting recordset.
You may want to remove this column if your application manipulate data from query directly without specifying column name.
So, please keep in mind that you are recommended to specify column names to manipulate data from resulting random query.