Are you using components for all your data access transactions (ie. dao, etc)? If so, and you are using ColdSpring (or some other bean factory) to manage your cfcs, this would be a perfect place for AOP. If you are not using a bean factory, you could create a lightweight aop style function / component method that looks something like:
FUNCTION doDBTransaction ARG1 - userId ARG2 - daoObject ARG3 - daoMethodToRun ARG4 - daoMethodArgs BEGIN TRANSACTION DO code to store current user in db SET returnval = daoObject.daoMethodToRun(daoMethodArgs) DO whatever cleanup code you may have END TRANSACTION RETURN returnVal If you are not using components for your db transactions you could possibly do something similar; perhaps passing in the name of templates that hold the queries. HTH Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309436 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4