user form validation trough another user

I'm new at this but i think this is a security question.
i'm using dreamweaver and i'm buildin a portal and i need to do this thing:
a user types some fields in a form to update some records in a database, then he sends a message or a email ou update a fiel in other database, for other user autorize that operation.
he continuos work and wend the autorization cames e click on a link and the pevius form is load with the same fields and if is autorized we can update (the database), if not go to another url

i alredy look in yahoo and and a can´t fiend an answer...
Who is Participating?
mrichmonConnect With a Mentor Commented:
It sounds like what you need to do is have a status flag on your record in the databse.

WHen the record is entered it gets status 0
Then an email gets sent to the person who will authorize
That person can authorize - if so set the status to 1 or not authorize - then set status to 2
In either case it sends an email back to person 1 saying a decision was made
The person looks and sees the decision - if it was authorized then you complete it and change the status to 4 - if it was denied then you send them to the other URL.

You need something like ASP PHP Cold Fusion to do this.....

Hope taht helps.
carlos_lxAuthor Commented:
ok can you send-me some code in asp... i´m new to preograming in asp i´m at the beginner, the only part that i need is the part of the email... how to make it send and how make it set the flag after the autorization
Here are links on how to send emails in ASP :
A Beginner's Guide to Sending Email from an ASP Page

ASP Web Based EMail Using Microsoft's CDONTS Tutorial
carlos_lxAuthor Commented:
ok i've think you don´t understand.. i need the code from both tables.. i´m going to explain more detaild my problem..
a user opens a page to update some values of a database... he submit the form to the administrator.. and this operations becomes in a stand by mode for him continue to work in the aplication.. wend the admistrator recives the form he autorize the modification or not and returns it to the user... the user recives the notification and submit it to the database to update data or if it's not autorized deletes the submission...
ok my problem is:
i'm using colldfusion and asp pages
how to send the forr to the administator (for example if it is by mail how to send the variable of control and recive it, and if it is by another form how to do this..), how to put the form in a stand by??? i need some code because i'm newer to programing..
iffffffffffffffffffyou want send the code for my email or the example pages...
How are you using cold fusion and ASP pages?

That doesn't really make sense.  Usually you use one ot the other.

You can send the information you need in a URL variable as a link back to the page where you approve the modification.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.