<cfquery datasource="#dsn#" name="pickids">
SELECT id
FROM diary
WHERE edpick = 'yes'
</cfquery>
<cfif pickids.RecordCount>
<cfset randpick = pickids.id[RandRange(1,pickids.RecordCount)]>
<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>
<cfelse>
<!--- do some other query --->
</cfif>
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
"Ian
Westbrook" To: "cfug dev list" <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
eam.net> Subject: [ cf-dev ] odd...
25/09/2003
10:04
Please
respond to
dev
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]
