What is the best method to append data?
Good Morning All,
Let me start by saying this is the one website I visit most for getting help. I don't ask questions as most of the posts here have been helpful for my projects, great participation & community effort. With that said here is my question.
I have a internal website that allows us to track work in our operations group, open outage tickets on equipment failures. I am able to wite a new ticket to the db, email selected groups, view and close the ticket. The MySQL table I created uses text fields which give me 65K of character space.
But, I also need to send updates and wonder which way is the preferred method of updating or appending the table field which holds the initial text notifying folks of the outage?
Should the initial data be held in a variable and displayed and allow the user to add the update as a new variable, concat the two variables together, write the data to the db?
If anyone has gone about this process let me know.
Sorry to be so long winded.
Enjoy,
Ron
|