How do you automate a process?

[Cirene]

i am creating an asp.net auction website

how do i create a process that will "end" the auction when it's time

obviously i don't want to sit at a browser and keep refreshing the page

i'm not sure if i can install an application on the server too (not
allowed?)

thanks...

[John Timney \(MVP\)]

Why do you have to do any form of polling - it could be ended when the next
person who requests anything to do with any auction triggers an end flag to
the previous auction if end time has passed.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

"Cirene" <te**@test.comwrote in message
news:ue**************@TK2MSFTNGP06.phx.gbl...

>i am creating an asp.net auction website

how do i create a process that will "end" the auction when it's time

obviously i don't want to sit at a browser and keep refreshing the page

i'm not sure if i can install an application on the server too (not
allowed?)

thanks...

[Mark Rae [MVP]]

"Cirene" <te**@test.comwrote in message
news:ue**************@TK2MSFTNGP06.phx.gbl...

how do i create a process that will "end" the auction when it's time

I'm not sure I understand your problem...

/* show the active acutions */
SELECT * FROM MyAuctions
WHERE EndDate getdate()

/* show the ended acutions */
SELECT * FROM MyAuctions
WHERE EndDate < getdate()

SELECT EndDate FROM MyAuction
WHERE AuctionID = 12345

if (Convert.ToDateTime(<EndDate>) < DateTime.Now)
{
// tell the user the auction has ended
return;
}

etc
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Cirene]

I was thinking of doing it this way, but these are exclusive type auctions
with not much traffic to the site. I was hoping that at the exact time it
ends to email me a notification, even if no one visits the site. But, this
is a good solution. Thanks John!
"John Timney (MVP)" <xy******@timney.eclipse.co.ukwrote in message
news:9I******************************@eclipse.net. uk...

Why do you have to do any form of polling - it could be ended when the
next person who requests anything to do with any auction triggers an end
flag to the previous auction if end time has passed.

Regards

John Timney (MVP)
http://www.johntimney.com
http://www.johntimney.com/blog

"Cirene" <te**@test.comwrote in message
news:ue**************@TK2MSFTNGP06.phx.gbl...

>>i am creating an asp.net auction website

how do i create a process that will "end" the auction when it's time

obviously i don't want to sit at a browser and keep refreshing the page

i'm not sure if i can install an application on the server too (not
allowed?)

thanks...

[Cirene]

Thanks.

"Mark Rae [MVP]" <ma**@markNOSPAMrae.netwrote in message
news:ef*************@TK2MSFTNGP03.phx.gbl...

"Cirene" <te**@test.comwrote in message
news:ue**************@TK2MSFTNGP06.phx.gbl...

>how do i create a process that will "end" the auction when it's time

I'm not sure I understand your problem...

/* show the active acutions */
SELECT * FROM MyAuctions
WHERE EndDate getdate()

/* show the ended acutions */
SELECT * FROM MyAuctions
WHERE EndDate < getdate()

SELECT EndDate FROM MyAuction
WHERE AuctionID = 12345

if (Convert.ToDateTime(<EndDate>) < DateTime.Now)
{
// tell the user the auction has ended
return;
}

etc
--
Mark Rae
ASP.NET MVP
http://www.markrae.net