CF Updating Database info

Question

Ok, hopefully I'll be able to describe this correctly because
as much as I look I can't find a solution anywhere...

I have a database that has information about Alumni in a
graduate program...I have created a simple search feature to
display specific information from the database on a website (
http://maitcf.stockton.edu/finalprojects/final.cfm).
It works fine....But...

What I would like to do is give the Alumni listed a chance to
update their information...I was thinking of adding an "Edit" link
in the results boxes that would take the user to a FORM where they
could edit the information for that specific result...

So I want the FORM to populate with information in the
database, and the user would change it or leave it the same, and
when they submit the FORM all of the information overwrites what
was in the DB....Is there any way to do this?

Newsgroup_User · Answer

Of course, this is the main reason for something like ColdFusion to
interact with database data.

But my first question to you is, are you going to let anybody edit
anybody else's records? That just sounds like a huge risk for abuse.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded