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

Reply via email to