How to INSERT INTO a specific row?

Ah, ok, I will try UPDATE.

Right now my form looks like this...

<cfform name="requestform" role="form"action="resources/requestform.cfm" method="post"  width="375" height="350" > 
    <label for="startdate">Start Date:</label>
      <label for="enddate">Finish Date:</label> 
    <cfcalendar name="selectedDate"  
        selectedDate="#Form.selectdate#" 
        startRange="#Form.startdate#" 
        endRange="#Form.enddate#"  
        mask="mmm dd, yyyy"  
        dayNames="SU,MO,TU,WE,TH,FR,SA" 
        firstDayOfWeek="1" 
        monthNames="JAN, FEB, MAR, APR, MAY, JUN, JUL, AUG, SEP, OCT, NOV, DEC" 
        style="rollOverColor:##FF0000" 
        width="200" height="150"> 
            <cfinput type="dateField" name="startdate" label="Start Date" width="100" value="#Form.startdate#">
            <cfinput type="dateField" name="enddate" label="End Date" width="100" value="#Form.enddate#"> 
    </div>
<cfinclude 
    template = "resources/query.cfm">
    <span class="label label-default">Equipment List</span>
    <table class="table table-bordered table-striped">
        <tr>
            <td><b>Select</b></td>    
            <td><b>Name</b></td>
            <td><b>Description</b></td>
            <td><b>Status</b></td>
        </tr>
    <cfloop query = "equiplist">
        <cfoutput>
        <tr>
            <td>
                <cfinput name="status" type="checkbox" value="#serial#">Select:</cfinput>
                <cfinput name="serial"type="text"style="display:none" value="#serial#">
            </td>    
            <td>#name#</td>
            <td>#descrip#</td>
            <td>#status#</td>
        </tr>
        </cfoutput>
</cfloop>
</table>
      <cfinput class="btn btn-default" type="Submit" value="Submit" name="addsubmit"></cfinput>
</cfform>

And the action page looks like this...

<cfquery
        name = "requestform"
        dataSource = "db_cie">
        UPDATE equip
        SET STATUS="Out",
        WHERE serial='#status#'
</cfquery>
<cflocation
    url = "../request.cfm">

But I am getting an error "invalid.user.table.column, table.column, or table specification. But the error message shows the SQL output and it looks correct...UPDATE equip SET STATUS="Out" WHERE serial="325255"... it IS getting the serial number variable passed from the form. ...No update though. Is my action form written wrong?