Why not this?
<cfquery name="getrecords" datasource="MINE">
SELECT *
FROM QUOTES
</cfquery>
<cfset RandNum = #RandRange(1,getrecords.RecordCount)#>
<CFLOOP QUERY="getrecords">
<CFIF CurrentRow EQ #RandNum#>
<CFOUTPUT>
Random Record No = #getRecordsrecord.ID#<BR>
Quote = #getrecords.Quote#<BR>
Author = #getrecords.Author#
</cfoutput>
</cfif>
</cfloop>
Larry Juncker
Senior Cold Fusion Programmer
Heartland Communications Group, Inc.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 09, 2000 3:50 PM
To: CF-Talk
Subject: random by day
Last week there was a discussion about pulling a random quote from a
database. I would like to pull a record from a database once a week, lets
say every sunday. Kind of like the quote of the week. Whats the best way to
do that?
KM
---------------------------------------------------
---------------------------------------------------
Get free personalized email at http://www.iname.com
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
