You need to cfset temp = Randomize(SomeNumber) before the RandRange... this "seeds" the (pseudo) Random Number Generator.
Hatton > <cfquery name="q_test" datasource="dbase"> > SELECT t_ID FROM t_testmain WHERE ID_testcat = 3 > </cfquery> > > <cfoutput query="q_test"> > <cfset Selecttest = #ListGetAt(t_ID, RandRange(1, ListLen(t_ID)))#> > </cfoutput> > > <cfquery name="DisplayTest" datasource="dbase"> > SELECT * > FROM t_testmain > WHERE t_ID = #Selecttest# > </cfquery> > > <cfoutput>#trim(displaytest.quote)#</cfoutput> > ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
