What's changing? the table? I'd have to apply that trigger to over 40 tables...and the parameters would be diff. for each one. I'd much rather store that in a cf file, personally....esp. since this app. is about to run on MySQL as well as SQL Server.
_____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Gomez Sent: Monday, June 04, 2007 2:03 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: Re: [DFW CFUG] List of executed files how about setting an OnChange event that fires off a function (js, cfscript or cfc)? Chris On 6/4/07, Johnny Thompson < <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED]> wrote: ok...looks like I didn't give you guys enough info on what I need. I need to be able to programmatically detect when certain files are executed for auditing purposes. additionally, I need to be able to log when I user modifies a record within a table....and since there are MANY tables in the application where I would care to capture that info, I'd rather simply detect when event occurs rather than explicitly creating logging routines for EVERY diff. instance. clear as mud now, right? So...I need to be able to determine what files have been executed (not to mention - what queries have fired) during an http request. Thanks _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Brett Roderick Sent: Monday, June 04, 2007 1:36 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: RE: [DFW CFUG] List of executed files I realized after posting my previous reply that you probably wanted to know what cfm files where included. The HTTP sniffer will only help with things like images and CSS or Javascript included files. -Brett _____ From: [EMAIL PROTECTED] [mailto: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] On Behalf Of Brett Roderick Sent: Monday, June 04, 2007 1:23 PM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: RE: [DFW CFUG] List of executed files You might consider using an HTTP sniffer. I'd recommend trying TamperData for Firefox (http://tamperdata.mozdev.org/index.html). -Brett _____ From: [EMAIL PROTECTED] [mailto: <mailto:[EMAIL PROTECTED]> [EMAIL PROTECTED] On Behalf Of Johnny Thompson Sent: Monday, June 04, 2007 11:58 AM To: 'Dallas/Fort Worth ColdFusion User Group Mailing List' Subject: RE: [DFW CFUG] List of executed files Interesting. However, I do not wish to create an arbitrary error to capture a list of executed files, if it can be avoided. Surely there is something else I can do... _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Woestman Sent: Monday, June 04, 2007 11:47 AM To: Dallas/Fort Worth ColdFusion User Group Mailing List Subject: RE: [DFW CFUG] List of executed files I was fixing a bug in a bit of a convoluted application created by another dev in my company who had recently left the company and intentionally placed an error in a page where I wanted to track what the order of execution was to get to that page. This information can be found by enabling robust error information or using a try/catch block and dumping the cfcatch results. Tom Woestman _____ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Johnny Thompson Sent: Monday, June 04, 2007 9:33 AM To: 'Dallas/Fort Worth ColdFusion User Group Mailing List' Subject: [DFW CFUG] List of executed files Anybody know of a way to detect what files have been executed on an http request? (includes, custom tags, etc.). Thanks again, Johnny Thompson _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ <http://www.mail-archive.com/list%40dfwcfug.org/> http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ <http://www.teksystems.com/> www.teksystems.com/ -- "Fortune favors the prepared mind." - Louis Pasteur
_______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.instantspot.com/ www.teksystems.com/
