hihi... hmm.. my customer required a booking request whereby the booking will be automatically cancelled after 3 days if it is not confirmed.
i have a Status Column for that booking table and a Booking Date column... so.. how do i enable the system to automatically update the status column ?? eg tblRoom===== 1. RoomID01 Booked 25/02/2002 2. RoomID02 Booked 25/02/2002 3. RoomID03 Confirmed 25/02/2002 4. RoomID04 Available 25/02/2002 5. RoomID05 Available 25/02/2002 today's is 28/02/2002.. so system is to run thru the database and update data 1 and 2 to available and date to 28/02/2002 hmm.. can i use CF server scheduled task to do it...?? or is there any such tool at Database side..?? i'm using mssql 2000... thanx han ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
