Cool! thanks! Marc
> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of Mike Lau > Sent: Friday, May 31, 2002 1:35 PM > To: [EMAIL PROTECTED] > Subject: RE: [CFTALKTor] random selection from database > > > >> <cfquery name="getPhoto" datasource="dsn"> > >> SELECT TOP 1 items, rand(either a unique_ID column or NewID() ) as > orderCol > >> FROM db table > >> ORDER BY orderCol #IIF(getTickCount() MOD 2, DE("ASC"), > DE("DESC"))# > >> </cfquery> > > >Just creating a newID will return the rows sequentially which > isn't random. > > to Marc, nope its not sequentially. NewID() in fact doesn't act like its > name sound like just creating a new id in a table/query, however it is a > build in function in MSSQL 2000 to create an unique value, and > it's random. > try it out in SQL2000 u will see =) > > to Graham, i think Dan's idea will work, probably it's the > easiest solution, > or try this (although it's not a prefect solution): > SELECT ((Rnd() * 100000) mod Any_Integer_Column) as OrderCol, * FROM > Your_TABLE ORDER BY OrderCol > > > rgds, > > ============================= > Mike Lau > Web Developer > > [EMAIL PROTECTED] > User In Mind Creative Group Inc. > > http://www.userinmind.com > Toll Free: 1-866-294-6644 > T: (416) 490-7556 > F: (416) 490-6889 > ============================= > > >Marc > > >- > >You are subscribed to the CFUGToronto CFTALK ListSRV. > >This message has been posted by: "Marc Campeau" <[EMAIL PROTECTED]> > >To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > >Manager: Kevin Towes ([EMAIL PROTECTED]) > http://www.CFUGToronto.org/ > >This System has been donated by Infopreneur, Inc. > >(http://www.infopreneur.net) > > - > You are subscribed to the CFUGToronto CFTALK ListSRV. > This message has been posted by: "Mike Lau" <[EMAIL PROTECTED]> > To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ > Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net) - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: "Marc Campeau" <[EMAIL PROTECTED]> To Unsubscribe, Please Visit and Login to http://www.CFUGToronto.org/ Manager: Kevin Towes ([EMAIL PROTECTED]) http://www.CFUGToronto.org/ This System has been donated by Infopreneur, Inc. (http://www.infopreneur.net)
