UPDATE and email confirmation

R

robert

I'm using FP 2000 and Access 2000 with DRW to display table results,
edit and update. I want to add an email confirmation option to my
update page. My web is CDONTS frinedly, after some websearching, I
found an old white paper from Microsoft with instructions on how to
INSERT INTO and email the results, but I cannot find anything on UPDATE
record and email updated results, is it possible? here is the code
microsoft supplied in the paper:

mySQL= "INSERT INTO Employees "
mySQL= mySQL & "(FirstName,LastName,Address,City,Region,PostalCode) "
mySQL= mySQL & "VALUES ('" & Request.Form("FirstName") & "','"
mySQL= mySQL & Request.Form("LastName") & "'"
mySQL= mySQL & ",'" & Request.Form("Address") & "'"
mySQL= mySQL & ",'" & Request.Form("City") & "','"
mySQL= mySQL & Request.Form("Region") & "','"
mySQL= mySQL & Request.Form("PostalCode") & "')"

I'm not a programmer but I've been trying to learn, can someone
recommend a web or online tutorial to help find an UPDATE and EMAIL
code?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

cdonts with asp/database record update 1
HELP - Insert/update date to Access database when records are changed 3
ASP - Cannot insert form result to Access DB more than one records 1
Error with SQL query included in .asp page. 1
Sending form results to database and email 0
Tracking Logins and Searc 0
Send Form results to database error 0
ASP and data submission into a database 5

Top