Hi, Phil... I'm not experience with XML, just vaguely familiar with it, but I'm curious as to why you're using XML as part of your process and not just interacting with a database only.
Rick > -----Original Message----- > From: Phill B [mailto:[EMAIL PROTECTED] > Sent: Monday, April 07, 2008 11:40 AM > To: CF-Talk > Subject: Can you guys give me your thoughts on this? > > 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:302859 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4