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:317462
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
