Include it in the onSessionStart method of Application.cfc and it will run only once per login.
If you really only want it once per day (if, for example, users sometimes logout/in several times per day), then you could add a date test to the log INSERT query: <cfquery ...> IF NOT EXISTS ( SELECT loginID FROM loginLog WHERE loginID = '#uCase(user)#' AND loginTime = <cfqueryparam cfsqltype="CF_SQL_DATE" value="#now()#" /> ) BEGIN INSERT INTO loginLog ( loginID, name, jobTitle, department ... [and so on] END </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328921 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
