CODEWITHSUNDEEP
inputcoldfusionattributestags
Phillip Perry
Phillip Perry

Reputation: 27

How do I populate a name value inside a Coldfusion CFOUTPUT

This is an update from a previous question. I'm not sure if this is even possible but I have a CFOUTPUT tag that has a single input tag inside it. This input tag equates to 65 possible checkboxes. The problem I'm having is trying to figure out what value to put in the name attribute of the input tag. I need 22 unique names that are static and don't change. My code is as follows:

<form action="new_processOptInfo.cfm"  id="displayOptions" method="post" name="displayOptions">

<cfoutput query="categorize" group="categoryName">
<h3>#UCASE(categoryName)#</h3>

<cfoutput>
<input type="checkbox" value="#idOptions#" name="option1"  /> #option#<br>
</cfoutput>
</cfoutput>
<input type="submit" value="Submit" name="submitOptions" id="submitOptions" />
</form>

So how do I name the input tag?

Upvotes: 0

Views: 533

Answers (2)

Regular Jo
Regular Jo

Reputation: 5510

In reply to a comment OP made.

In plain English I want to have unique names for my checkboxes that are generated automatically. I thought that when you INSERT values into a table the form tag names have to be unique

(This reply was just too many characters to leave as a comment.)

For the record, field names don't have to be unique. Cold Fusion receives duplicate field names' values in a comma delimited list. There's actually great use in that. You can have 50 checkbox named p_IDs and if 3 are checked cold fusion will recieve the values checked (like 7,15,32, if those were the values checked).

This is extremely useful with cfloops like

<cfloop list="#form.p_IDs#" index="p">Product #p# selected</cfloop>.

You can name corresponding input field, like textboxes like

<input name="desc_#dbID#" type="text">
<input type="checkbox" name="p_IDs" value="#dbID#">

And then in the cfloop on processing page use code like

<cfloop list="#form.p_IDs#" index="p">
  Product #p#'s description is #form["desc_#p#"]#
</cfloop>

You could place an insert query into the cfloop (or an update, or delete query).

Examples of where this is useable is say if you wanted to mass delete selected rows, rather than deleting each row individually.

This functionality (works in a similar fashion across nearly every language) is the beauty of checkboxes. You can name them different things, but why would you want to? As far as radio buttons, naming them different things defeats their purpose.

On the subject of other input elements though, certainly name them different things.

Upvotes: 1

Phillip Perry
Phillip Perry

Reputation: 27

As @FishBelowtheIce said option1 is being sent to the action page as a list so when I was made aware of that and looped through it. I just had to fix my typos and it worked. The code below is what I have now.

<cfif IsDefined("form.submitOptions")>
  <cfloop index="index" list="#options#" delimiters="," >
      <cfquery name="updateInsOpTable" datasource="applewood">
         INSERT INTO ins_opt_table
         ( address,option1,option2,option3,option4,option5,option6
          , option7,option8,option9,option10,option11,option12
          , option13,option14,option15,option16,option17,option18
         )
         VALUES (#form.address#, #options#)
      </cfquery>
  </cfloop>
</cfif>

Upvotes: 0

Related Questions