String index out of range: -2
hI I get the string index out of range when I submit my form. String index out of range: -2 I am trying to use a cfinsert using formfileds thanks --see code below. The error takes place at line 104 at the cfinsert. I am not seeing whey thank you
<!---action page---> <cfinsert datasource="webAdmin" tablename="grantProjects"
formfields="proj, age, region, county, roadname, bmp, emp, authfund, totalCost, dateFunded, enddate, software, narrative, article">--->
form code:
<cfform action="/Funding/Grants/RAP/ProjectAdministration/insertProjectData.cfm" method="post" format="html">
<fieldset>
<legend>Insert Project
</legend>
<div class="register">
<label for="age">Age Type</label>
<cfselect name="age" id="age" required="no" message="Specify project age type.">
<option value="" selected="selected">Select an option</option>
<option value="active">Active</option>
<option value="complete">Complete</option>
<option value="older">Older</option>
</cfselect>
</div>
<div class="register">
<label for "proj">Project#:</label>
<cfinput type="text" name="proj" id="proj" required="no" message="Project number is required."></div>
<div class="register">
<label for "proj">RAP Region:</label>
<cfinput type="text" name="region" id="region" required="no" message="RAP Region is required."/>
</div>
<div class="register">
<label for="county">County:</label>
<cfselect name="county" required="no" id="county" message="County is required.">
<option value="">Select a County</option>
<option value="Adams">Adams</option>
<option value="Asotin">Asotin</option>
<option value="Benton">Benton</option>
<option value="Chelan">Chelan</option>
<option value="Clallam">Clallam</option>
<option value="Clark">Clark</option>
<option value="Columbia">Columbia</option>
<option value="Cowlitz">Cowlitz</option>
<option value="CRAB">CRAB</option>
<option value="Douglas">Douglas</option>
<option value="Ferry">Ferry</option>
<option value="Franklin">Franklin</option>
<option value="Garfield">Garfield</option>
<option value="Grant">Grant</option>
<option value="Grays Harbor">Grays Harbor</option>
<option value="Island">Island</option>
<option value="Jefferson">Jefferson</option>
<option value="King">King</option>
<option value="Kitsap">Kitsap</option>
<option value="Kittitas">Kittitas</option>
<option value="Klickitat">Klickitat</option>
<option value="Lewis">Lewis</option>
<option value="Lincoln">Lincoln</option>
<option value="Mason">Mason</option>
<option value="Okanogan">Okanogan</option>
<option value="Pacific">Pacific</option>
<option value="Pend Oreille">Pend Oreille</option>
<option value="Pierce">Pierce</option>
<option value="San Juan">San Juan</option>
<option value="Skagit">Skagit</option>
<option value="Skamania">Skamania</option>
<option value="Snohomish">Snohomish</option>
<option value="Spokane">Spokane</option>
<option value="Stevens">Stevens</option>
<option value="Thurston">Thurston</option>
<option value="Wahkiakum">Wahkiakum</option>
<option value="Walla Walla">Walla Walla</option>
<option value="Whatcom">Whatcom</option>
<option value="Whitman">Whitman</option>
<option value="Yakima">Yakima</option>
</cfselect></div>
<div class="register">
<label for "proj">Road Name:</label>
<cfinput type="text" name="roadname" id="roadname" required="no" message="Road name is required.">
</div>
<div class="register">
<label for "bmp">Mileposts:</label>
<cfinput type="text" name="bmp" id="bmp" required="no" message="Beginning Milepost is required.">
-
<cfinput type="text" name="emp" id="emp" required="yes">
</div>
<div class="register">
<label for "authfund">RATA-CAPPA Funds:</label>
<cfinput type="text" name="authfund" id="authfund">
</div>
<div class="register">
<label for "totalCost">Total Cost:</label>
<cfinput type="text" name="totalCost" id="totalCost">
</div>
<div class="register">
<label for="dateFunded">Date Funded:</label>
<cfinput type="text" name="dateFunded" id="dateFunded">
</div>
<div class="register">
<label for="enddate">Completed:</label>
<cfselect name="enddate" id="enddate">
<option value="">Select a Year</option>
<option value="1985">1985</option>
<option value="1986">1986</option>
<option value="1987">1987</option>
<option value="1988">1988</option>
<option value="1988">1899</option>
<option value="1990">1990</option>
<option value="1991">1991</option>
<option value="1992">1992</option>
<option value="1993">1993</option>
<option value="1994">1994</option>
<option value="1995">1995</option>
<option value="1996">1996</option>
<option value="1997">1997</option>
<option value="1998">1998</option>
<option value="1999">1999</option>
<option value="2000">2000</option>
<option value="2001">2001</option>
<option value="2002">2002</option>
<option value="2003">2003</option>
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006">2006</option>
<option value="2007">2007</option>
<option value="2008">2008</option>
<option value="2009">2009</option>
<option value="2010">2010</option>
<option value="2011">2011</option>
<option value="2012">2012</option>
<option value="2013">2013</option>
<option value="2014">2014</option>
<option value="2015">2015</option
></cfselect>
</div>
<div class="register">
<label for="software">Design Software:</label>
<cfinput type="text" id="software" name="software">
</div>
<div class="register">
<label for "narrative">Narrative File:</label>
<cfinput type="text" id="narrative" name="narrative"></div>
<div class="register">
<label for "story">Article:</label>
<cftextarea name="story" cols="50" rows="5" id="story" title="Text entered in this field will display on the Project page." style="text-align:left;">
</cftextarea>
</div>
<cfinput type="submit" name="submit" value="Add Project">
<cfinput type="reset" name="Reset " value="Reset Form">
</fieldset>
</cfform>
AdChoices