Hi guys, Well, I fixed my other problems after a bit of fiddling (the coding ones, anyway...). This new one is just a logic thing which I'm having trouble figuring out.
I have a query that looks through the Product table in the database and finds all the products that are listed as "on special". What I want to do is select a random item from the recordset returned by this query and output it into the sidebar of the site so that every time you visit the page you see a random product that is on special. How do I go about doing this? Do I have to apply some randomisation logic to the query, or is it something done post-query? And what is the logic I need to apply? I've gone around in circles on this one and I just can't work it out. Thanks, Seona. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
