Best way for Editing Details?

Hi all,

I have a MS SQL Server table with my customers and wish to be able to edit their details with ColdFusion.

What are the best steps for this page(s) and what are the functions I should be using? What are the functions for?

Thanks in advance
LVL 1
samsung_81Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
anandkpConnect With a Mentor Commented:
Steps wld be :

1. Select teh data in the table & show the user
<cfquery name="Qry_User" Datasource="DSNName">
    select name, lastname, email from tbl_customer where name = 'samsung' <!--- use CFQueryParam for all ur queries - helps caching & better security --->
</cfquery>

2. Show teh data in a tabular format to the user - so he can decide if he needs to edit
<cfoutput Query="Qry_User">
       #name# - #lastname# - #email#
</cfoutput>

3. when the user clicks on EDIT - again use steps 1 & 2 to show him the data - but this time in a EDITABLE format - ie with the use of TextBoxes & Form Controls.

4. the user can edit teh details [U'll need Javascript to make sure that the edits are as per the (Project/DB) requirements] by submitting the form.

5. On submit - have server validations take care of teh inputs by the user & make sure they are as per the (Project/DB) requirements. once confirmed

<CFQuery DataSource="DSNName">
    Update tbl_customer
    set    lastname = '#Form.lastname#',
            email      = '#form.email#'
    where user = 'samsung'
</CfQuery>

that shld get u started ...
0
 
mrichmonCommented:
More info :

Besides what anadkp said....

You should have the users access this page over SSL and have to log in first.

Be sure to use server side validation of the submitted fields with things like regular expressions to ensure they are entering allowable data
(If you need help let us know)
0
 
samsung_81Author Commented:
thanks anandkp

but can you give some more details on steps 2-4?

im guessing from step 2 and 3, i can use the listed customer as a link with an URL variable to the "edit customer" page. correct?

with step 4, what functions other than javascript are available within coldfusion for me to edit that customer's details in a form-like view?

Thanks again
0
All Courses

From novice to tech pro — start learning today.