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:265361 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
