Question
Checkbox Multiple Deletes
I use the following code to display display all line items
from a query, and put in checkboxes for each line item, so that if
the box is checked, that line item will be deleted :
<cfoutput query="qry">
<tr>
<td align="center"><input type="checkbox" name="del_#urdn_number#_#urdn_line_item#" value="Yes"></td>
<td align="center">#qry.line_item#</td>
<td align="center">#qry.action#</td>
<td align="center">#qry.quantity#</td>
the action page :
<cfloop index="i" list="#form.fieldnames#" delimiters=",">
<cfif left(i,4) is "del/">
<cfset select_urdn_number = listgetat(i, 2, "/")>
<cfset select_urdn_line_item = listlast(i, "/")>
What I need to do now is add a input text field, to each line item displayed, for the user to enter comments explaining why they watn to delete that line item. I then need to insert this comment that corresonds to each line item into a table.
Since this comments input text is not part of the query, how do I associate it with each line item ?
<cfoutput query="qry">
<tr>
<td align="center"><input type="checkbox" name="del_#urdn_number#_#urdn_line_item#" value="Yes"></td>
<td align="center">#qry.line_item#</td>
<td align="center">#qry.action#</td>
<td align="center">#qry.quantity#</td>
the action page :
<cfloop index="i" list="#form.fieldnames#" delimiters=",">
<cfif left(i,4) is "del/">
<cfset select_urdn_number = listgetat(i, 2, "/")>
<cfset select_urdn_line_item = listlast(i, "/")>
What I need to do now is add a input text field, to each line item displayed, for the user to enter comments explaining why they watn to delete that line item. I then need to insert this comment that corresonds to each line item into a table.
Since this comments input text is not part of the query, how do I associate it with each line item ?
