You could choose a random number from [1] to [recordcount], and use a
counter variable to get to that record.
Or, if you have an identity key that's a autonumber you could use that...
> -----Original Message-----
> From: Jeremy Bunton [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 16, 2001 4:32 PM
> To: CF-Talk
> Subject: random record
>
>
> 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.
>
> JLB
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
