# Determining active dates for queued items?

Discussion in 'ASP General' started by FrankEBailey, May 21, 2007.

1. ### FrankEBaileyGuest

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.

FrankEBailey, May 21, 2007

2. ### Bob Barrows [MVP]Guest

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"

Bob Barrows [MVP], May 21, 2007