Forums
This topic is locked
ASP, auto execute query when the date= end of year
Posted 04 Jun 2007 06:29:50
1
has voted
04 Jun 2007 06:29:50 chong lu yen posted:
hi there,i know maybe this topic has been discussed by other member, but i still not understand how is work.
i hope can get more detail solution on it.
i wan to do a page at the backend,when the date is end of this year(12/31/2007) then will execute the code (such as add the new total leave with the current balance leave automatically without regresh the page or login into the system.)
i heard that the MS SQL SERVER got this triggered function, but unfortunately..the MS SQL SERVER hosting that i used(third party) didnt provide this function. i jz can store data in the table and create database..no more others component that i can use. so i duo how can i solve it.can give me some idea on the coding?i m newbie in asp.
i hope can hear from u all soon coz the problem is urgent..
plz help..
thank you very much