Re: random record

[Jennifer]

At 04:31 PM 1/16/01 -0500, you wrote:
>Can anyone point me in the right direction regarding how I would go about
>pulling a random record from a table every time a user visits the page.

query the table as normal

use RandRange(1,#query.RecordCount#) to select a random number

Output only that record like so.

#query.field1[randomnumber]#


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists