Solved

How to place multiple forms in ond coldfusion templete..

Posted on 2004-09-02
6
178 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Apached AXIS end to end simple good example 2 85
.htaccess rewrite url with querystring problem 13 88
Annoying "thing" blocks my view 4 83
listing all functions in JavaScript 19 180
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…
Introduction In this tutorial, I'll explain how to create an animated progress meter in a wireframe prototype developed using Axure RP 7.0 - a leading prototyping tool for designing web sites and software. (For more information about Axure and gett…
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 integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Setti…

863 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now