2. ASPRunnerPro General questions
  3. send updated record to owner Email
This topic is locked

send updated record to owner Email

 		6/25/2010 7:44:47 PM
ASPRunnerPro General questions
M
 magma7247 author

Hi,
I have two table ,
1- database and named as "database"

2- second table named "Employees" and it has users username , passwords, Emails
what I want to do, once I update a record in the database, I need the owner of that record will receive email with the updated values
how I can do this ?
regards.
Sergey Kornilov admin 6/26/2010

To do so you need to make sure main table and Employees table are linked. I assume that both those tables have a common EmployeesID field.
sql = "select email from Employees where EmployeeID = " & values("EmployeeID")

set rstmp = CustomQuery(sql)
Now rtmp("email") contains user email address that you can use in your code.