Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

How to place multiple forms in ond coldfusion templete..

Posted on 2004-09-02
6
Medium Priority
?
186 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 1500 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 learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

When setting up new project requests for our site, one of the most powerful tools our team has available to use is Axure (http://www.axure.com/). It’s a tool for creating software and web prototypes that can function and interact as if it were the a…
Dramatic changes are revolutionizing how we build and use technology. Every company is automating, digitizing, and modernizing operations. We need a better, more connected way to work together as teams so we can harness the insights from our system…
The purpose of this video is to demonstrate how to insert an Iframe into WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Open Page or Post…
The purpose of this video is to demonstrate how to set up the permalinks on a WordPress Website. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Go t…

971 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