> I think this if very doable in CF, but my mind goes to VB for
> stuff like this.
>
> I would write an NT Service that would watch this directory,
> load all new files one at a time, parse the data as required,
> and insert into you SQL database. The Service would be installed
> on the server that has the directory in question and run based
> on the timing interval you think appropriate.
>
> Not a trivial task, but doable...
You could even make it easier, and do most or all of this from within the
database; I've seen nifty examples of this with SQL Server 7.0.
> For those who feel I'm a trader to CF, I like to reserve CF
> Server and it's scheduled tasks for the critical web apps, not
> for what I consider to be internal housekeeping.
That's the way to do it. Use the right tool for the job.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.