If you are using SQL Server, then I think the best way would be to set up a trigger is sql server that will do the checking.
-----Original Message----- From: han peng [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 28, 2002 10:21 AM To: CF-Talk Subject: Auto running of Codes to update data.. 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 ______________________________________________________________________ Why Share? Dedicated Win 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=coldfusionc FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
