I'm building a contest site with CFMX and MySQL. On it is a thumbnail view page
that displays all the approved photos in a random order every time you enter a
particular page. Here's the SQL code I'm using for this call:
<cfquery name="qFindPhotos" datasource="dsn">
SELECT display_photo FROM contest WHERE approved='yes' ORDER BY RAND();
I'm now running into an instance where there are a lot of images to display;
too many for one page and I need to split it up among several pages.
The problem is the ORDER BY RAND(); - this is random each time the page ...