is DSN being set I do not see a open cftry
does the query throw an error? On 8/26/07, Richard Dillman <[EMAIL PROTECTED]> wrote: > > Its almost 3 am and Maybe that's the problem, > > I seem to have no problem getting Directory Watcher to work in the admin, > and logging the information into with CFLog, > but what I cannot do is log the information to the database with a Query. > What am i forgetting here? > > <cfcomponent> > <cffunction access="public" name="onChange" output="no" > returntype="query"> > <cfargument name="CFEvent" type="struct" required="yes"> > <cfset data=CFEvent.data> > <cfquery name="qryInsertTest" datasource="#DSN#"> > SET NOCOUNT ON > INSERT INTO [eventlist] ([Updated]) > VALUES (<cfqueryparam cfsqltype="CF_SQL_TIMESTAMP" > value="#dateformat(data.lastmodified)#" null="No">) > </cfquery> > </cftry> > <cflog file="MydirWatcher" application="No" > text=" ACTION: #data.type#;FILE: #data.filename#; > TIME: #timeFormat(data.lastmodified)#"> > </cffunction> > </cfcomponent> > > Their is only one file that will be updated via FTP, so I guess the next > question is, Can I have Directory Watcher watch only one file? > > > -- > -- > Richard Dillman > [EMAIL PROTECTED] > (317) 916-8341 > > "I will always give you what you ask for, its just not usually what you > want" > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287137 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
