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

["Todd Kirk" <tkirk@xxxxxxxxxxxxxx>]

regards,
 
Todd Kirk

> Hi,
> As far as I know this is not possible from the database 
> itself. Putting 
> business logic into the data-tier isn't a good strategy. You 
> better run 
> a program in which this logic is and let the program send the 
> email. If 
> you ever want to switch to another database you don't have to rewrite 
> our businesslogic.
> 
> Johan

So you don't recommend the use of a trigger or stored procedure or
similar? The idea is that if he program is not run then the email would
never be sent.

The client needs to receive the email whether they login to their web
application or not. Hence my thinking that the db has to trigger and
send the email....not some ASP page that may not be visited and
therefore run. Is my logic correct here?

Perhaps you could define what you mean by 'program'?