Oops... that newid() would be useful only in SQL Server. It's all I use lately and therefore assume it's all everyone else uses. ;-) What database?
..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 9:49 AM To: CF-Talk Subject: RE: problem with rotating news Randomly, you'd select top 3 and order by newid() Sequentially, you could do it a few ways I'm sure. One way would be to initially store all the IDs in a list or whatever in a session variable. Each time the page is viewed, grab the first 3 IDs from the list, get those records, then move those 3 IDs to the end of the list. So the next time the 3 IDs are grabbed, they are the next ones in line. ...:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: alex poyaoan [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 8:22 AM To: CF-Talk Subject: problem with rotating news Hi everybody I need help on how could i achieve rotating news.. I have 12 news items on the database and i want it to rotate it showing only 3 items everytime i refresh the page.. tried using top 3 but how could i rotate it.. thanks to all ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:279461 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
