I'm using access and FP 2000 to update records online, I'm trying to
find a/the code to update a record (NOT INSERT INTO) and send an email
confirmation, and I'm having a difficult time finding it. I've used FP
wizard to create the table display, and edit, but I cant program the
UPDATE page to both update the record and send an email confirmation.
I copied the code from an old CDONTS white paper from microsoft:

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") & "')"

And that works fine, it inserts and emails, but I want to send a
confirmation when an individual or administrator updates an individuals
record, and I CANT FIND ANYTHING! Please help, i'm new at this...not a
programmer but if you can recommend a tutorial I should be able to work
through it. Thanks in advance, the webserver is cdonts friendly.

After you've inserted, use a select to retrieve the record to confirm the
record exists.

I'd recommend CDOSYS instead of CDONTS, since it supports CSS better and
CDONTS is deprecated.

Try here http://www.brainjar.com/asp/formmail

HTH;

Amy

"robert" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I'm using access and FP 2000 to update records online, I'm trying to
> find a/the code to update a record (NOT INSERT INTO) and send an email
> confirmation, and I'm having a difficult time finding it. I've used FP
> wizard to create the table display, and edit, but I cant program the
> UPDATE page to both update the record and send an email confirmation.
> I copied the code from an old CDONTS white paper from microsoft:
>
> 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") & "')"
>
> And that works fine, it inserts and emails, but I want to send a
> confirmation when an individual or administrator updates an individuals
> record, and I CANT FIND ANYTHING! Please help, i'm new at this...not a
> programmer but if you can recommend a tutorial I should be able to work
> through it. Thanks in advance, the webserver is cdonts friendly.
>