I need some input on this. I need to keep track of changes made to products in our database. The best thing I have come up with that meets the customers needs is using CF to track the product using XML. The product will be stored in the database but all the versions of it would be stored on the server in XML with the transactions being recorded in it.
Here is how I think it should work but it just doesn't feel right yet. A new product is created so an XML file is written to the server with the date and user name attached. When a potential change is made, the current product will be compared to the most current XML to see if anything really was changed. If a change is detected, a new XML file is written to the server with the date and user name attached to the change. Does this sound solid enough to use or is there a better way? All input is appreciated. It would be great if I could find an easy way to integrate Subversion, CF and SQL2K for this but that's just crazy talk. :-) Thanks -- Phil ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:302851 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
