|
cdrees -> Append data to existing Record (6/15/2007 12:40:17)
|
Hello all,
been awhile since I've posted here.. I'm stumped, and thought I'd save the last few hairs on my head by asking the experts.. [:D]
Environment:
Dreamweaver CS3
IIS 6.0
ASP
MS SQL 2000
I have a simple database that has the following fields:
ID:
Server Name:
Status
Serial Number:
Model:
CPU:
CPU Speed:
RAM (GB):
Disk Type:
# Disks:
Disk Size (GB):
# Power Sups:
Store Only:
History:
Redeploy Reason:
I want to maintain a history of what happens with the piece of hardware (server), when it gets checked in and checked out of inventory (when status changes from Available to Redeployed), or when any field is edited (changed).
So basically, I want the existing history field to be appended to upon an update.
I want it to look like this basically:
quote:
6/15/2007 11:53:07 AM
Server added to Database
6/15/2007 12:15:07 PM
Status changed from Available to Redeployed
6/15/2007 12:22:07 PM
Status changed from Redeployed to Available
6/15/2007 1:53:07 PM
RAM changed from 8 to 4
etc....
Each of the entries above would be appended to the history record each time something gets updated.
Again, I'm using Dreamweaver CS3, IIS 6.0 and MS SQL 2000.
Thanks guys and gals!!
-Chris
cdrees@gmail.com
|
|
|
|
