>> 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.
The database would be better suited to store the information than an XML file unless you want to transmit that XML info without going to the DB. We have done something similar except that the customer wanted a change log of all changes. We created a "change_log" table in the DB and used the unique product ID as one of the fields. When a change was made to the product we recorded the date, the revision, and various info like the person who initiated the change, the department who wanted did it...etc and other details of the changes in that table. That way when someone wanted to know what changed in a product we could query against the "change_log" table to see the history. Dennis Powers UXB Internet - A website design and Hosting Company http://www.uxbinternet.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:302988 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
