Thanks for your help Guys! I think i will write a program to process my web logs...i thought there were a clean, simple and smart solution :-)
By the way, here is the code i use to get a random record <!--- Query to get all my ID ---> <cfquery name="GetID" datasource="#REQUEST.DSN#" dbtype="ODBC" cachedwithin="#CreateTimeSpan(0,1,0,0)#"> SELECT UserID FROM USERINFO WHERE </cfquery> <!--- Building a list with a random ID ---> <cfset UserIDList = valueList(GetID.UserID)> <cfset ListPosition = randRange(1,ListLen(UserIDList))> <cfset RandomUserID = ListGetAt(UserIDList,ListPosition)> <cfquery name="GetUserID" datasource="#application.DS#" dbtype="ODBC"> SELECT column1,column2 etc.FROM USERINFO WHERE UserID = #RandomUserID# </cfquery> This code is From Builder.com Thanks again, R�mi ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc 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
