RE: [cobalt-developers] OT ? Interbase - how to have auto email when db date value is current date

["William L. Thomson Jr." <wlt@xxxxxxxxxxxxxxxxxxxx>]

Todd,

	I second the recommendation to write a program that is executed by
cron.

On Thu, 2003-03-06 at 14:52, Todd Kirk wrote:
>
> I can make a ASP page to do all that and then simply make that page a
> cron job...can't I?

Not easily. In my opinion I do not think it is possible. Not with the
current implementation of ChiliASP on the Cobalts. The server itself
from a command line point of view does not have the ability to process
the ASP code.

In your situation you could use a shell script, although I have no idea
how you would extract data from the db using a shell script.

I believe you will end up with your choice of C, C++, Java, Perl, or
Python. You will need to use a language that from command line can be
interpreted.

FYI, Java is not as easy as the others. You must include a classpath and
etc. On my machines I do have Java installed and a classpath, but had to
pass the classpath along when executing my java program via cron.
 
> Any pointers or URL for me to achieve this would be great.

I used to have some java classes to do things like this, and will have
some more soon. I have ported allot of the java classes to C++ for speed
purposes. Since some would be run every 15 minutes or less. Others run
hourly or daily.

As for tutorials? You are looking for a couple things. A tutorial on how
to write a program in your language of choice to extract data from the
db. Then you will need a tutorial on how to get cron to call you
program, which frankly should be fairly obvious.

If you have questions let me know and I will see what I can do to
assist.

-- 
Sincerely,
William L. Thomson Jr.
Obsidian-Studios, Inc.
439 Amber Way
Petaluma, Ca. 94952
Phone  707.766.9509
Fax    707.766.8989
http://www.obsidian-studios.com