I have 5 <cfinput> that I need to be save on my DB.

But the problem is that on my DB I have only 2 columns one for the ID and the other for the value from the <cfinput>

What is the best way to do this and not use 5 Insert, one for each <cfinput>.
Is there a way to loop thru the <cfinput>?

Ennio,

If you name the input boxes the same, when you submit the form the values will be put into a list in the form variable of whatever you named all the text boxes.

You can then loop through the list to do your inserts.

Ennio,

Jason was kind enough to answer similar question for me a couple of weeks ago. You can read the thread here:

http://forums.hostmysite.com/viewtopic.php?t=3917

This may help.

Susie

Hi guys thank you, I found this solution that worked for me.

I always recommend StructKeyExists() over isDefined

Sean CorField will even back that up

http://corfield.org/blog/index.cfm/do/blog.entry/entry/isDefined_vs_structKeyExists