I want to output an 'editor's pick' on the front page of my site - I've selected 5
records from the Diary as edpicks, and am using this code:
<cfquery datasource="#dsn#" name="pickids">
SELECT id
FROM diary
WHERE edpick = 'yes'
</cfquery>
<cfset list = valuelist(pickids.id)>
<cfset picklist = ListLen(list)>
<cfset place = randRange(1,picklist)>
<cfset randpick = ListGetAt(list, place)>
<cfquery datasource="#dsn#" name="edrandpick">
SELECT diary.id AS diaryid, diary.title, diary.startdate, diary.enddate,
diary.directoryid, diary.artform AS diaryartform, diary.eventimage, diary.company,
directory.id AS directoryid, directory.fullname AS fullname, directory.town, towns.id
AS townid, towns.town, artforms.id, artforms.artform AS artform
FROM diary, directory, towns, artforms
WHERE (len(diary.eventimage) > 0)
AND
(( diary.startdate >= #nowdate#)
or
( diary.enddate >= #nowdate#))
AND diary.directoryid = directory.id
AND diary.artform = artforms.id
AND directory.town = towns.id
AND diary.id = #variables.randpick#
</cfquery>
most of the time it works fine, but sometimes the random event isn't output at all (so
I guess edrandpick.RC=0). Anyone any idea why?
http://test.artsoutheast.co.uk to see it in action (assuming you _do_ see it, of
course, if not reload the page a few times).
TIA
Ian W
