<CFWTF>

Sharing a name among checkboxes

Posted At : May 10, 2007 7:42 AM | Posted By : name
Related Categories: ColdFusion

Here's a tip you might have missed. Did you know if you reuse a name for more than one checkbox control in your form, your result on the processing side is a comma-delimited list? This is particularly useful for numeric IDs. Check out this reporting app:

<cfquery name="qStatuses" datasource="#dsn#">
SELECT ID, Name FROM Status
</cfquery>
<cfparam name="Form.StatusIDs" default="#valueList(qStatuses.ID)#">

<cfquery name="qEmployees" datasource="#dsn#">
SELECT * FROM Employee WHERE Status IN (#Form.STatusIDs#)
</cfquery>

<form method="post">
Include:
<cfloop query="qStatuses">
   <cfset vChecked = "">
   <cfif listFind(Form.StatusIDs, qStatuses.ID )>
      <cfset vChecked = " checked">
   </cfif>
   <input type="checkbox" name="StatusIDs" value="#qSTatuses.ID#" #checked#> #qStatuses.Name#
</cfloop>
</form>

Results
<cfloop query="qEmployees">
   ...etc.
</cfloop>

Because all the checkboxes have the same name ("StatusIDs"), then the value that comes through on the processing side as a comma-delimited list of the IDs of the checkboxes that the user checked, which fits quite nicely in our IN() statement in the query.

And before you cry out about the user not checking any of them, remember that an unchecked checkbox does not even get submitted as a value, so in that case, the would fire, providing a nice you-clearly-don't-know-what-you-want-so-I'll-just-give-you-the-default mechanism.

Comments (0) |

Print |

Send |

del.icio.us |

Digg It! |

Linking Blogs | 286 Views

Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

There are no comments for this entry.

[Add Comment]