| | |
Form Processing - Multiple Lines
Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Nov 2008
Posts: 6
Reputation:
Solved Threads: 0
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.
•
•
Join Date: Jan 2009
Posts: 20
Reputation:
Solved Threads: 1
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
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
![]() |
Similar Threads
- Help with automatic update problem and more (Viruses, Spyware and other Nasties)
- Send data on a serial port (C++)
- memory management in wndows 2000 (Windows NT / 2000 / XP)
- This Should be Easy for You Guys! (Linux Servers and Apache)
Other Threads in the ColdFusion Forum
- Previous Thread: New to this and a little ignorant, but need help
- Next Thread: How to check for duplicate records on multiple insert
Views: 868 | Replies: 1
| Thread Tools | Search this Thread |
Tag cloud for ColdFusion





