Ok I think I fixed it. I forgot to ORDER BY newID()
Thank you. > New Problem. A have advertisements but want to assign them to > different pages. I guess im just new to it all and lack the thinking. > > > Im trying to set it all up to where you can put it in three locations > if you want. Im using ORs but the ORs stop the query once it finds > something. So if I have an AD that is assigned to All News and one > assigned to Local Events.. It will only pull the first with All News. > > > Anyone help me. Newbie question. > > > <!--- Calls up record table ---> > <CFQUERY DATASOURCE="#green#" NAME="GetADs"> > SELECT top 1 * > FROM dbo.banner_trans > WHERE (page_location = 'All News') > OR (page_location2 = 'All News') > OR (page_location3 = 'All News') > OR (page_location = 'Every Page') > OR (page_location2 = 'Every Page') > OR (page_location3 = 'Every Page') > OR (page_location = 'Local Events') > OR (page_location2 = 'Local Events') > OR (page_location3 = 'Local Events') > > </CFQUERY> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:317464 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4