> > 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

Reply via email to