Hi,

I am designing a small advertisement management program in asp, and Sql Server 2000 as database.

My table has the following fields which are pretty self explanatory:


bannerId, bannertitle, bannerurl, imageURL, bannerpirority

bannerId = Autoincrement to generate unique id for a banner ad
bannertitle = String title of the banner
bannerurl = URL where the image is linked
imageURL = URL of the image file
bannerpirority = pirority of the banner to be displayed (1 = lowest, 5 = highest)


Now, I want to display the banner on a page based on its pirority, like if there are 3 banners A, B, C which have the pirority 1,2,3 respectively so banner C should be displayed more times as compared to banner B. Banner B should be displayed more times then banner A


Hope you got me, its like the more pirority a banner gets, the more its being displayed.


I am using the following SQl Query but I dnt think its the proper logic, can u plz help me?

Thanx in advance for your help.

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

__________________
-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Testing is the best judge. How is it working now? Are you getting the results you want?

This may not be the best solution but I would just enter the banner into the tbl_banner as many times as I would like to increment the ratios and then just use the newid() function to select random records.

You can select DISTINCT from the table so that you only get one instance of a banner when editing.

Highest priority would insert 5 records or you could increase the ratios. If 5 is your highest priority then insert the record 25 times. If 1 is lowest and want that banner very infrequently, just INSERT once. I don't know what your table relationships are but you could always create a lookup table that INSERT's as many times as you want the priority level to be, a table that just holds the ID column value from tbl_banner and the ID from the lookup table:

BannerID LookupID
1 1
1 2
1 3
1 4
1 5
2 6
3 7
3 8

Then just select from the Lookup table using NEWID() an the ratios should match what you're looking for.

????
P

Hi,

I have not yet received a satisfying reply so far :(

Ok lets tweak this a lil bit.

we can have a percentage based ad management system.

Like I have 3 banners in my database.

Banner A - To receive 50% Views
Banner B - To receive 30% Views
Banner C - To receive 20% Views

So suppose I refresh the page 10 times, I should get the following views of my banners

Banner A - 5 views
Banner B - 3 views
Banner C - 2 Views

Can u guys help me with this?


Thanx in advance

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Use the adrotator, it should suit your needs perfectly.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

with an ad rotator I cannot monitor how many views an ad has got.

Am I right?



-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

With out doing a little custom coding of your own, no.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

can u plz guide me how to?

I am a newbie :)

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

I wont guide you step by step, but i will give you the general theory.

Read this post about the ad rotator: http://www.w3schools.com/asp/asp_adrotator.asp

as you can see you use:

response.write(adrotator.GetAdvertisement("ads.txt ")) to display a given ad to your page. Of course this does not allow you to track what is going on at all. Sooooo.

Write a function that acceptes adrotator.GetAdvertisement("ads.txt") as its argument, execute your business rules on which ad is being viewed (base on the argument that you have supplied) when you have completed your processing, simply return the value that was originally passed in.

so your final line may look like:
response.write(processAd(adrotator.GetAdvertisemen t("ads.txt")))

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

I have no clue how to make that function :(a

-----------------------------------------------
www.chargertek.in - Cheapest WebHosting

Creating functions in asp:
http://www.4guysfromrolla.com/webtec...ner/faq5.shtml

instead of using response.write in the function you will want to return the value

function foo(param)

foo = param
end function

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from planoie's profile^^
^^Modified text taken from gbianchi profile^^
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========