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"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion 8 - Build next generation apps
today, with easy PDF and Ajax features - download now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287136
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
