I am working on publishing items of Articles CT to the database. I want to be able to record in the db table, the publish time of the each item, the first time the items were published to the database.
How do I go about this?
Has anyone done something similar to what I am trying to do here ?
Which database are you using?
This may be more of a db question than Rhythmyx. In SQL2000-5 You could create a column in your db published table that had a default value of the current time (getdate()) so everytime a new record was inserted it would be populated by the current time. Then have a trigger on update to populate another field everytime the row was updated.
I figured it out but thanks for your response. I appreciate.