this should work (i think):
<CFOUTPUT>
#myQuery.myColumn[RandRange(1,myQuery.recordcount)]#
</CFOUTPUT>
Bert
> -----Original Message-----
> From: David Crowther [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2000 10:51
> To: Fusebox
> Subject: Random record?
>
>
> Does anyone know of a quick and easy way of requesting a
> random record from
> a table.
>
> For example: A query that selects a random record from a
> field (say UserID)
> from a table (say tblUser). So when each time the page is
> viewed, a new
> record is displayed.
>
> All help very much appreciated!
>
> David
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
