Re: Directory Questions - How would I do this?

Well ... if you're creating a file based on database input, why do you need a separate process to monitor the directory? Couldn't emailing the person be the next step:

  1. do sql
  2. if ( new record )
     2a. save file to directory
     2b. email interested user
[download]

And I would probably place something like this in cron over sleeping for 30 minutes.

-derby

Comment on Re: Directory Questions - How would I do this? Download Code

Replies are listed 'Best First'.
Re^2: Directory Questions - How would I do this? by jdlev (Scribe) on Jan 20, 2009 at 20:42 UTC
I'm very new to programming, so I have no idea how sql would know what a new record was. The database it pulls from is read only, so I can't update anything there. I love it when a program comes together - jdhannibal	[reply]
Re^3: Directory Questions - How would I do this? by runrig (Abbot) on Jan 20, 2009 at 21:16 UTC
I have no idea how sql would know what a new record was. I think we assuming from your original post that you were already getting the new records from the database, and that you were probably using some sort of SQL to retrieve the records. Not being familiar with the database, I couldn't say what that SQL was (or even whether or not it's a SQL database), so I hope you do have some way of getting the new records	[reply]
Re^4: Directory Questions - How would I do this? by jdlev (Scribe) on Jan 20, 2009 at 21:28 UTC
I love it when a program comes together - jdhannibal It pulls information from a DBase IV file if that helps at all?	[reply]