randRange(1,myquery.recordcount). That'll give you a random row. Then
use the primary key to do whatever you need form there. HTH.
--Jeff
Dustin Snell [Network Automation, Inc] wrote:
> We have a database with a bunch of customer testimonials in it.
> Records can
> be added to it at anytime. Some are marked public and some or not. Does
> anyone know how I could pull a single record randomly from the database
> using MSSQL2000 and CF6.1 for display on the website - but only out of the
> records where public=1? I am just not sure how to structure the query
> to do
> this.
>
> Thanks in advance.
>
> Dustin Snell
> Network Automation, Inc
> www.networkautomation.com
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
