|
| |
|
|
cdrees
Posts: 42
Joined: 8/4/2004
Status: offline
 |
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.. 
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
|
|
|
|
mar0364
Posts: 3026
Joined: 4/5/2002
From: Florida, US
Status: offline
|
RE: Append data to existing Record - 6/15/2007 17:13:07
Hello Chris!
If you just want to change the content of one field keeping the most recent change thats not hard. But if you want to keep a running history I would recommend using a trigger to update a maintenance table. If your using the developer toolbox this is also fairly easy.
Regards!
Rich
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
|
|
cdrees
Posts: 42
Joined: 8/4/2004
Status: offline
|
RE: Append data to existing Record - 6/15/2007 17:22:08
Ah..
Well, that's part of the issue... I'm not sure how to do all that. I've been trying to look triggers up and I'm familiar with the basic concepts, but to be honest I'm new to most of this.
I want to keep a history of the various changes... all the changes, so the field could grow fairly large over time..
Any help would be appreciated, and I'm sure others would learn too!
Thanks so much.
| |
|
|
|
mar0364
Posts: 3026
Joined: 4/5/2002
From: Florida, US
Status: offline
|
RE: Append data to existing Record - 6/16/2007 20:14:23
Sounds like you want to go with a trigger that updates a maintenance tracking table.
quote:
ORIGINAL: cdrees
I want to keep a history of the various changes... all the changes, so the field could grow fairly large over time..
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
|
|
cdrees
Posts: 42
Joined: 8/4/2004
Status: offline
|
RE: Append data to existing Record - 6/18/2007 9:44:05
Can you point me to how to do that?
I've been searching, and I can't find anything that really outlines the process
Thanks!
| |
|
|
|
mar0364
Posts: 3026
Joined: 4/5/2002
From: Florida, US
Status: offline
|
RE: Append data to existing Record - 6/18/2007 16:37:19
In the ASP and Databases forum on this site there are folks that can tell you how to do it from scratch. I'm not one of those people.
I would do it following this methodology in Dreamweaver.
Link
_____________________________
Easy Web
“Stay committed to your decisions, but stay flexible in your approach.”
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
