as long as ou are not using access there is a RAND() function to do it...
something like this if i remember correctly
select * from table order by Rand() limit 1
that SHOULD return 1 random record everytime its ran.
you could also get all of the IDs from the table and then select a radom ID from the #ValueList(QueryName.QueryColumn)# variable
like...
<cfquery name="IDs" datasource="datasource">
select ID from table
</cfquery>
<cfset randomID = listGetAt(valuelist(IDs.ID), RandRange(1, listlen(Valuelist(IDs.ID)))>
then just select * from table where ID = #val(randomid)#
the caching part is easy, it is an attribute of the cfquery tag and as long as its not cleared or the server rebooted, or CF services restarted, then it should last the full cached duration...
for 24 hours...
<cfquery name="QueryName" datasource="datasourcename" cachedwithin="#createtimespan(0,24,0,0)#">
select whatever
</cfquery>
** CreateTimeSpan(Days,Hours,Minutes,Seconds)
----- Original Message -----
From: daniel kessler
To: CF-Talk
Sent: Tuesday, August 03, 2004 1:36 PM
Subject: Re: tip of the day
> Id stick with ID and tip, pull a random one each time and cache the
> query for 24 hours.
That brings up some questions. So, I pull a random tip each day, not a random tip each page refresh. So what pulls the random tip and sets it as the TOTD? I've also not yet looked into caching queries. ugh
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
