ta ;-) Ian W
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 4:40 PM Subject: Re: [ cf-dev ] odd... > > <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] > -- ** 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]
