I have a Cold Fusion front end where I want to populate a MySql
database with archive information.
The front end puts in status and I then copy the old status to a latest
history field. Then if the status gets updated it does the same thing
but the history info is deleted.
Now I want to add an archive field to be able to keep appending so I
can keep all of the history.
UPDATE theTable
SET archive = "archive" "lastesthistory",
lastesthistory = "status",
status = "form.status"
WHERE projId = projID
Please advise because the above sql is not ...
Bookmarks