Gossamer Forum
Home : Products : DBMan SQL : Discussion :

variables in Email after modify a record

Quote Reply
variables in Email after modify a record In reply to
That code works nicely, thanks.

Users in my db can add / modify records in several tables. I'd like the email to contain the table name they have added to. How would I modify the above code to do that please?

Once I have the table name I presume I can use $hsh->{column_name} to put a bit more useful information into the email.

I'd also like to be able to send the user a confirmation email. Is there an easy way of getting the email address out of the users table?
Tim Ault
Oxford UK
Subject Author Views Date
Thread Email after modify a record hoefti 10950 May 16, 2002, 11:54 AM
Thread Re: [hoefti] Email after modify a record
jean 10803 May 24, 2002, 12:03 PM
Thread Re: [jean] Email after modify a record
hoefti 10692 May 30, 2002, 6:01 AM
Thread Re: [hoefti] Email after modify a record
hoefti 10270 May 30, 2003, 3:30 AM
Thread variables in Email after modify a record
timbo 10141 Sep 19, 2003, 12:33 AM
Thread Re: [timbo] variables in Email after modify a record
timbo 10032 Sep 20, 2003, 1:15 AM
Thread Re: [timbo] variables in Email after modify a record
jxh 10052 Oct 8, 2003, 3:21 PM
Thread Re: [jxh] variables in Email after modify a record
timbo 9945 Nov 15, 2003, 4:59 AM
Thread Re: [timbo] variables in Email after modify a record
timbo 9947 Nov 18, 2003, 6:42 AM
Thread Re: [timbo] variables in Email after modify a record
timbo 9866 Nov 28, 2003, 2:31 AM
Thread Re: [timbo] variables in Email after modify a record
604 9884 Nov 28, 2003, 10:41 AM
Post Re: [TheStone] variables in Email after modify a record
timbo 9903 Nov 29, 2003, 12:47 AM
Post Re: [hoefti] Email after modify a record
billgrveles 9251 Oct 5, 2006, 8:42 AM