<div>
Thank you, I don't know why I forgot about &quot;IN&quot;. I did have to do it this way though: IN (&lt;cfqueryparam value = &quot;#form.SELECTED#&quot; list=&quot;true&quot; CFSQLType = &quot;CF_SQL_BIGINT&quot;&gt;)
</div>


Thank you, I don't know why I forgot about "IN". I did have to do it this way though: IN (<cfqueryparam value = "#form.SELECTED#" list="true" CFSQLType = "CF_SQL_BIGINT">)

<div>
<div class="content wysiwyg-content">
I have a text field and some checkboxes. When the form is submitted the check boxes create a list. The field is called &quot;selected&quot;. So, After the form is submitted I have a 2 fields, one is a list of numbers(selected) &nbsp;like this 3,7,9,10 and a value from the text box &quot;car&quot;, <br />
<br />
The values from &quot;Selected&quot; are the IDs from each record i would like to update. So, if the boxes 5,6,7 were checked I want to update records with ID 5,6,7 with the value from the text box. <br />
<br />
Could someone assist with this? I'd like to avoid having a query in a loop. Thank you.
</div>
</div>


I have a text field and some checkboxes. When the form is submitted the check boxes create a list. The field is called "selected". So, After the form is submitted I have a 2 fields, one is a list of numbers(selected)  like this 3,7,9,10 and a value from the text box "car", 

The values from "Selected" are the IDs from each record i would like to update. So, if the boxes 5,6,7 were checked I want to update records with ID 5,6,7 with the value from the text box. 

Could someone assist with this? I'd like to avoid having a query in a loop. Thank you.

Update multiple records from a list

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.