Sorry... got to start thinking before I start typing!
Thanks heaps Bert...
David
-----Original Message-----
From: Bert Dawson [mailto:[EMAIL PROTECTED]]
Sent: 12 December 2000 11:16 AM
To: Fusebox
Subject: RE: Random record?
er, not sure how that could happen - this isn't outputting based on a value
in the column, but the row number of the recordset that you've just
queried....
Bert
> -----Original Message-----
> From: David Crowther [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2000 11:10
> To: Fusebox
> Subject: RE: Random record?
>
>
> Thanks Bert. But another question!
>
> What happens if the random number try's to display a record
> that has been
> previously deleted?
>
> David
>
> -----Original Message-----
> From: Bert Dawson [mailto:[EMAIL PROTECTED]]
> Sent: 12 December 2000 10:57 AM
> To: Fusebox
> Subject: RE: Random record?
>
>
> 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
