I am working on parking permit web application. A user is directed to viewcar.asp page after login. I would like to have the user mark one of his/her car as an “Active” car.
- Viewcar.asp shows all the cars that associate with this user.
- Each car showed on veiwcar.asp has an Edit link. The Edit link brings the user to
editcar.asp page to edit car table.
- My car table has a filed call, Status.
This is what I want to do:
When the Status field is changed to “Active”, the Status of all other cars that are associated with this user must set to “Inactive”.
I wonder what is the most straight forward way to accomplish this task?
If I were to use a database Trigger, how would I do so?
I use Macromedia Dreamweaver MX 2004 for ASP pages and MS SQL Server 2000 Database.
Thank you very much!!!