<cfset randpick = ListGetAt(list, place)>
<cfif variables.randpick EQ 0> <cfset randpick = ListGetAt(list, place)> </cfif>
HTH
Dave
At 9/25/2003 10:04, you wrote:
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
-- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
