You could run a query to get the min and max, then use RandRange to get your random id. That should get you started.
******************* Hi there, An easy one for a Friday morning... I have a table that lists submitted photos, and would like to have a random photo generator that reads from this table in the database. What's the best way to select one random PhotoID from the table and then use it within a <cfoutput> to display a photo? - You are subscribed to the CFUGToronto CFTALK ListSRV. This message has been posted by: [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)
