> > ORDER BY Rnd(fld_page_ID) > > This command keeps pulling the same order, even if I close the browser. > If they go back to the main page I would like possibility of having a > different news item appear.
Keith, This is a ColdFusion caching issue. If you run the query directly in Access, you will see that it does properly return random records. Make sure you have the newest CF DB drivers from Adobe. Also, despite what everyone is eluding to, Access is not the devil tool that they are making it out to be. I have a couple of very active legacy apps that have been running for close to 10 years on Access. I don't use it for any new sites, but there is also no need for me to scramble to move them. Yes, it does not scale like a true server based databases (MS SQL, mySQL, etc.), but depending on your circumstances, it should probably perform fine. For web based applications, it only needs to support a single user, which is ColdFusion. And in actually, it will allow for multiple users in a network environment sharing a single DB. It is not the greatest (locking issue primarily), but it does work for some people. Long term, you will probably want to migrate to one of the other DB apps, but just by telling you so doesn't help you with your immediate problem. Just my .02 cents. Dean ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314264 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4