Solved

How to place multiple forms in ond coldfusion templete..

Posted on 2004-09-02
6
182 Views
Last Modified: 2013-12-24
I was wondering what is the best practice if i have a function which requires 2 Forms several querys and
1 insert...

Here is my flow

user sees inital form and enters customer id and submits query
    - query is executed to see if valid customer
if valid customer we display new form with e-mail address field
   -if invalid we displa an error
if cusomer submits new form, we will execute a inset query...

i have done this with parameterexists and checked what submit the user pushed. is there a cleaner way to do this ?
0
Comment
Question by:AlexPonnath
  • 2
6 Comments
 
LVL 21

Expert Comment

by:pinaldave
ID: 11969098
Hi AlexPonnath,
 user sees inital form and enters customer id and submits query
     - query is executed to see if valid customer
 if valid customer we display new form with e-mail address field
    -if invalid we displa an error
 if cusomer submits new form, we will execute a inset query...
Looks effcient already. There are only five step anyway.
Well, what else you are thinking of that could be done. As we do not know much of the requirement what to suggest.
If above mentioned is the flow then it is fine.

Though the questions is that ... what happens if the user comes to second page directly due to any reason... is that possible...
what about database... do you have any identity or unique field... which may conflict...
(if valid customer do not know/fogot its id or login info  - this may be irrelivent here...may be)


Regards,
---Pinal
0
 
LVL 35

Accepted Solution

by:
mrichmon earned 500 total points
ID: 11969171
The best practice is to display only one form.

Just have cold fusion render the form differently depending on the user action and then have the action page determine if an insert or edit is needed and execute the corresponding action.
0
 
LVL 17

Expert Comment

by:anandkp
ID: 11970361
I wld say just have one form - with customer id & e-mail address [agree with mrichmon]
so the user submits once - u query just once ... no issues at all - the user is happy & so are u ;)

thou - have javascript for validating ur ID & email address - so u cld do the basic validations at client side itself & dont make the user go back & forth for silly typos.

K'Rgds
Anand
0
 
LVL 35

Expert Comment

by:mrichmon
ID: 12202795
Is there more of an answer that you wanted?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
What You Need to Know when Searching for a Webhost Provider
The purpose of this video is to demonstrate how to reset a WordPress password if you are locked out and cannot reset the password. A typical use would be if you cannot access the email to which WordPress would send the password recovery email to…
The purpose of this video is to demonstrate how to set up an RSS Feed on a WordPress Website. This will be demonstrated using a Windows 8 PC. Feedburner will be used for this demonstration. Go to your WordPress login page. This will look like the…

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question