form.cfm
<form action="handler.cfm" method="post">
    StartIP <input type="text" name="startIP" value="10.1.5.0" />
    <br><br>

    EndIP <input type="text" name="endIP" value="10.1.5.255" />
    <br><br>

    Status  <select name="ipStatus">
                <option>1</option>
                <option>2</option>
                <option>3</option>
                <option>4</option>
            </select>
    <br><br>

    Group <input type="text" name="groupName" value="workgroup" />
    <br><br>

    <input type="submit" value=" GO " />
</form>


handler.cfm
<cfscript>
// NOTE : just assuming all data is correct from the form
startIP     = form["startIP"];
endIP       = form["endIP"];
ipStatus    = form["ipStatus"];
groupName   = form["groupName"];

// setup vars for loop processing
xx          = listToArray( startIp, ".")[4];    // first IP in range
_endBit     = listToArray( endIp, ".")[4];      // last IP in range
_ipPrefix   = Replace( startIp, ".#xx#", "" );  // trim off the final .999 to get ipPrefix
insertArray = ArrayNew(1);  // temp array to hold insert values


// loop through ip range and create VALUES list for SQL INSERT
while( xx <= _endBit )
{
    // append each row's value to array
    ArrayAppend( insertArray, "( '#groupName#', '#_ipPrefix#.#xx#', #ipStatus# )" );
    xx++;
}
// convert array to comma delimited list
insert_values = ArrayToList( insertArray, "," );

// cleanup
ArrayClear( insertArray );
</cfscript>


<cfoutput>
<cfquery name="insert_data" result="insert_result" DATASOURCE="#request.dsn#" USERNAME="#request.dbuser#" PASSWORD="#request.dbpswd#">
INSERT INTO GROUP_IPS ( group_id, ip_address, status )
VALUES
#PreserveSingleQuotes( insert_values )#
</cfquery>
</cfoutput>