Updating multiple records

I have this query :
<cfquery name="qry" datasource="dsname">
select line_item, part_no, qty
from tblName
where ref_no = '#form.ref_no#'
</cfquery>

Lets say that I return five records. I then display them in a table, in form mode, for editing

<form action="form_action.cfm" method="post">

<table>
<cfoutput query="qry">
<tr>
<td><input type="hidden" name="line_item" value="#qry.line_item#"></td>
<td><input type="text" name="part_no" value="#qry.part_no#"></td>
<td><input type="text" name="qty" value="#qry.qty#"></td>
</tr>
</table>

<input type="hidden" name="ref_no" value="#form.ref_no#">

<input type="submit" value="submit">

</form>

All five records are displayed and any column can be changed. When I go to the action page to update my table, how would I do that ?

Would I loop thru the update process five times, with where ref_no = '#form.ref_no#' and line_item = '#form.line_item#", or is there another way to do this. I have just updated single records, but not multiples like this.

Thanks for any suggestions.