943,791 Members | Top Members by Rank

Ad:
  • ColdFusion Discussion Thread
  • Unsolved
  • Views: 982
  • ColdFusion RSS
Mar 1st, 2009
0

Form Processing - Multiple Lines

Expand Post »
Newbie: I am executing a query that outputs mutiple lines and pages of potential players for a golf match. The name is displayed and a checkbox. If the checkbox is checked, an email is to go to the person on the line that has been checked. Being a newbie, I have no idea how to process each line individually after the form has been submitted since the name of the field is the same on each line. Help please.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
bvaz is offline Offline
6 posts
since Nov 2008
Mar 2nd, 2009
0

Re: Form Processing - Multiple Lines

What you need to do is loop over each value and do an update sql statement to insert a flag to say that you have emailed the player.
You will also need to concatenate a number against the form input names to generate unique names.
You can get the value back out of these parameters by using the evaluate function before insertion into the db.
To email each player, you will need to loop over a cfmail code block .
Its pretty straight forward when you get your head around what needs to be done.
Do you know how to write cfc's?
Is so you could write a function that would handle all of this. I have written many functions in my applications to handle thistype of updating.
Have a go first and post your code, from there i can help you build on the app if you like.

cheers

JM
Reputation Points: 10
Solved Threads: 1
Newbie Poster
jedimatt is offline Offline
20 posts
since Jan 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ColdFusion Forum Timeline: New to this and a little ignorant, but need help
Next Thread in ColdFusion Forum Timeline: How to check for duplicate records on multiple insert





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC