Solved

How to place multiple forms in ond coldfusion templete..

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

Have you ever sent email via ColdFusion and thought of tracking this mail to capture the exact date and time when the message was opened ?  If yes, then this article is for you ! First we need a table user_email with columns user_id , email , sub…
If you don't have the right permissions set for your WordPress location in IIS, you won't be able to perform automatic updates. Here's how to fix the problem.
The purpose of this video is to demonstrate how to create a Printer Friendly PDF on a WordPress Page. This will be demonstrated using a Windows 8 PC. Tools Used are Photoshop, Awesome Screenshot” Google Chrome Extension, and SmallPDF.com Log…
The purpose of this video is to demonstrate how to Import and export files in 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 : Click on Too…

813 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

13 Experts available now in Live!

Get 1:1 Help Now