Hi,
I have a limited number of ad slots on my website, let's say there are
5. I have lots of people wanting to advertise in those slots, let's
say there are 100. They each join the queue for an ad slot on a first-
come, first-served basis. I have been trying to find a way to
determine the active date for a queued item. For the first five items
in the queue it's easy, it's just the expiry date of the item in a
live slot that expires first. For the next five queued items it's
still easy, because it's just the expiry date of the item in the queue
that will expire first. HOWEVER, after that it becomes more complex,
because the queued items will continually be slotting into live slots
as live items expire. So my question is, is there a straightforward
way, in ASP, of determining the active date for a queued item in a
queue of arbitrary size?
Any and all help or suggestions appreciated.
Thanks in advance! 1 1499
FrankEBailey wrote:
Hi,
I have a limited number of ad slots on my website, let's say there are
5. I have lots of people wanting to advertise in those slots, let's
say there are 100. They each join the queue for an ad slot on a first-
come, first-served basis. I have been trying to find a way to
determine the active date for a queued item. For the first five items
in the queue it's easy, it's just the expiry date of the item in a
live slot that expires first. For the next five queued items it's
still easy, because it's just the expiry date of the item in the queue
that will expire first. HOWEVER, after that it becomes more complex,
because the queued items will continually be slotting into live slots
as live items expire. So my question is, is there a straightforward
way, in ASP, of determining the active date for a queued item in a
queue of arbitrary size?
Any and all help or suggestions appreciated.
Thanks in advance!
How is the expiry date determined? Are you storing the amount of time
purchased and adding that to the active date? I assume the amount of timed
purchased can vary ... What unit of time is sold? And is there a minimum
purchase?
I assume you are storing this stuff in a database. Can you give us an idea
of the table structure and what type and version of database you are using?
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM" This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Joshua Beall |
last post by:
Hi All,
I am wondering what the best way to determine an age of something/somone is.
For instance, let's say I have two dates:
1985-07-19
2003-11-30
Now, I want to determine the interval in years, and for each fraction of a
year, days. I won't mess with months because they can have variable length,
|
by: Chris Q. |
last post by:
I am creating a custom control that contains a list view with dates and times. I need to make sure that times do not overlap. I would like the control to determine if the overlap is occuring with the starting time or with the ending time and offer the user an adjusted time entry. Below is the code I'm using currently to check the date and time. How would I modify it to detect where the overlap is occuring.
Public Sub Add(ByVal StartTime As...
|
by: DartmanX |
last post by:
Is there a simple way to determine if someone using Internet Explorer
has completely disabled ActiveX controls?
Jason
|
by: whidbeywave |
last post by:
Hello all,
Help me understanding this situtation. While debugging a scenario for
error 403.9 on IIS/XP Pro, I added two counters to perfmon app.I saw at
some point of time Session Active =0 , but requests executing was
greater than zero. Summarizing it
Session Active =0
Requests Executing =10
Requests in application Queue =0
All this time I had assumption that request that undergo execution lock
|
by: Martin Robins |
last post by:
I am currently looking to be able to read information from Active Directory into a data warehouse using a C# solution. I have been able to access the active directory, and I have been able to return "DirectoryEntry" objects within the path that I specify (either using the DirectoryEnrtry.Children or using the DirectorySearcher class) and all started well and dandy!
Now the problem; some of the properties of the DirectoryEntry objects being...
| |
by: van_haan |
last post by:
My database of customers has customers with begin_date and end_date.
Each year has 13 periods (each 4 weeks begins a new period).
I have a problem with calculating number of active customers per
periods, 13 of them.
For example:
If begin_date of customer A is 02-01-07 and end_date is not filled in
the customer should be counted as active till today (19-03-2007) which
means that he should be counted as active in the periods 01, 02, 03 if...
|
by: jaccess |
last post by:
Hello,
I am running MS ACCESS 2003 and have run into a seemingly simple problem. Hopefully all I will need is a quick fix.
I have a report based on a query that lists a date, items received, items processed, and items remaining. The query gets a date range from a form. I am trying to total the items received, items processed, and items remaining fields.
When the report is run without anything like =Sum() in the footer, the dates are...
|
by: Gordon |
last post by:
I am currently working on some code for my CMS that creates a site
folder, then creates all the necessary child folders inside it. The
method that creates folders needs to insert into 2 tables so it wraps
the operation in a transaction. (psuedocode below)
public function createItem ($parent)
{
$this -database -beginTransaction ();
$this -database -query ('INSERT INTO items (param1,
param2 ... ) values (val1, val2 ... )');
|
by: BeckR |
last post by:
Hello:
Thanks for reading my post. I am trying to generate Athletic League schedules using Access 2003 and Windows XP PRO. I am using DateSerial in a text box to print the game dates on the League schedule report. This is the control source for one of the dates on my report.
=DateSerial(Year(),Month(),Day(+7))
The problem I am having is that if the day is a Holiday then I do not want to print the schedule information for that...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| |
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |