You could also perhaps have a column in your news table that indicates whether an article is old or current. Then all you'd have to change is the value of one column for each article that gets "deleted". Or maybe the extra column would just indicate that the article is archived. So the column name could be "Archived" and the value could be the boolean indicating whether it was archived.
How about something like that? Cheers, Chris Bruce Sorge wrote: > Sure. When they delete the article I assume you are passing through some > unique ID number. Just take that ID number, run an insert query that does a > select sub query of the live article and insert it into the archive table, > then delete the current one. Make sure to wrap it all in a CFTRANSACTION tag > so in case something goes wrong it is not deleted. > > Bruce > > On 12/29/06, Steve LaBadie <[EMAIL PROTECTED]> wrote: > >> I created an admin panel for a client with the typical add, delete, modify >> features. My client has a news section on their website along with an >> archive section for old news. My client wants the old news to be placed in >> the archive section when it is deleted from the current news page through >> the admin panel. Is this possible? Any ideas? >> >> Steve >> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265366 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
