Gossamer Forum
Home : Products : DBMan : Discussions :

Added and Modified notification?

Quote Reply
Added and Modified notification?
Is there a way for the administrator to be notified if a record is added "or" modified, without using validation?


Modification: I just found on JP Deni's site the mod to Send email after record is added . This takes care of half the problem, the other half, is notification if the record has been "modified" as well.


Thanks for the help.

Last edited by:

bbooker: Apr 11, 2002, 8:05 AM
Quote Reply
Re: [bbooker] Added and Modified notification? In reply to
I would think all you would have to do is add the same code in the modify_success subroutine.
_______________________________________________________
Lem Motlow, Proprietor Lynchburg (pop 361), Tenn.
Quote Reply
Re: [Lem Motlow] Added and Modified notification? In reply to
Yes, that worked with a bit of a twist, (other than the one where I feel a little stupid Crazy).

%rec=&get_record($in{$db_key});

open (MAIL, "$mailprog") or &cgierr("unable to open mail program");
print MAIL "To: $admin_email\n";
print MAIL "From: $admin_email\n";
print MAIL "Subject: New Record at $html_title\n\n";
print MAIL "A record was modified at $html_title with the following information:\n\n";
foreach $column (@db_cols) {



THIS:
print MAIL "$col -- $rec{$col}\n";


Had to be changed to:

print MAIL "$column: $rec{$column}\n";



}
print MAIL "\n\n";
close MAIL;

After that it worked great. Thanks to you, JP, and eveyone else for all the help.