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
