I am pulling a query into a cfgrid and if the value pulled in is NULL,
when I select that row, and try to edit it using my textbox, it doesn't
work. I have another form that is almost identical and it works
perfectly. Could someone please look at my code and let me know if
they see any issues. Thanks in advance!

<cfform ACTION="/athletics/releases/admin/update_roster.cfm?page=2"
METHOD="POST" name="form" format="flash" width="540" height="600"
skin="haloOrange">
<!--- show grid --->
<cfgrid format="flash" name="roster" width="540"
query="getRoster" onchange="for (var idx_rs:Number = 0;
idx_rs<student_id.length; idx_rs++) {if
(student_id.getItemAt([idx_rs]).data == roster.selectedItem.student_id)
student_id.selectedIndex = idx_rs};">
<cfgridcolumn name="id" header="ID" display="no">
<cfgridcolumn name="sport" header="Sport" display="no">
<cfgridcolumn name="season" header="Season" display="no">
<cfgridcolumn name="player_number" header="Num.">
<cfgridcolumn name="student_id" header="Student ID">
<cfgridcolumn name="position" header="Pos.">
<cfgridcolumn name="bat_throw" header="B/T">
<cfgridcolumn name="player_height" header="Height">
<cfgridcolumn name="player_weight" header="Weight">
<cfgridcolumn name="hs" header="HS">
</cfgrid>

<!--- buttons to add / delete rows --->
<cfformgroup type="horizontal" name="buttons">
<!--- Use the insertRow method in the onClick event to add a
row. This also prefills the sport & season columns.--->
<cfinput type="button" name="InsertRowDirectImpactGrid"
value="Create New Player" width="125"
onClick="GridData.insertRow(roster);roster.dataPro vider.editField(roster.selectedIndex,
'sport',
sport.text);roster.dataProvider.editField(roster.s electedIndex,
'season', season.text);">

<!--- Use the deleteRow method in the onClick event to delete
the selected row--->
<cfinput type="button" name="DeleteRowDirectImpactGrid"
value="Delete Selected Row" width="130"
onClick="GridData.deleteRow(roster)">

<cfformitem type="spacer" width="40" />

<!--- submit all changes --->
<cfinput type="submit" name="submit_btn" value="Submit to Save
Changes">

</cfformgroup>

<cfformgroup type="panel" label="Update Player">
<cfformgroup type="horizontal">
<!--- sport displayed, but not editable --->
<cfinput type="text" name="sport" value="#Trim(q_sport)#"
label="Sport" width="150" disabled>

<cfformitem type="spacer" width="20" />

<!--- season displayed but not editable --->
<cfinput type="text" name="season" value="#Trim(q_season)#"
label="Season" width="100" disabled>
</cfformgroup>


<cfformgroup type="horizontal">
<!--- player's name drop-down --->
<cfselect name="student_id" label="Athlete" size="1"
width="200"
onChange="roster.dataProvider.editField(roster.sel ectedIndex,
'student_id', student_id.selectedItem.data);">
<cfloop query="getStudents">
<option value="#studentid#">#lastname#, #firstname#</option>
</cfloop>
</cfselect>
</cfformgroup>


<cfformgroup type="horizontal">
<!--- player number --->
<cfinput type="text" required="no" name="player_number"
label="Player's Number" width="50" message="Player's Number Required"
bind="{roster.dataProvider[roster.selectedIndex]['player_number']}"
onChange="roster.dataProvider.editField(roster.sel ectedIndex,
'player_number', player_number.text);">

<cfformitem type="spacer" height="20" />

</cfformgroup>


<cfformgroup type="horizontal">
<!--- position field --->
<cfinput type="text" required="no" name="position"
label="Position" width="50" message="Position Required"
bind="{roster.dataProvider[roster.selectedIndex]['position']}"
onChange="roster.dataProvider.editField(roster.sel ectedIndex,
'position', position.text);">

<cfformitem type="spacer" width="20" />

<!--- bat / throw field --->
<cfinput type="text" name="bat_throw" label="Bat / Throw"
width="50"
bind="{roster.dataProvider[roster.selectedIndex]['bat_throw']}"
onchange="roster.dataProvider.editField(roster.sel ectedIndex,'bat_throw',
bat_throw.text);">
</cfformgroup>


<cfformgroup type="horizontal">
<!--- height field --->
<cfinput type="text" required="no" name="player_height"
label="Height" width="50" message="Height Required"
bind="{roster.dataProvider[roster.selectedIndex]['player_height']}"
onChange="roster.dataProvider.editField(roster.sel ectedIndex,
'player_height', player_height.text);">

<cfformitem type="spacer" width="20" />

<!--- weight field --->
<cfinput type="text" required="no" name="player_weight"
label="Weight" width="50" message="Weight Required"
bind="{roster.dataProvider[roster.selectedIndex]['player_weight']}"
onChange="roster.dataProvider.editField(roster.sel ectedIndex,
'player_weight', player_weight.text);">

</cfformgroup>


<cfformgroup type="horizontal">
<!--- high school field --->
<cfinput type="text" required="no" name="hs" label="High
School" width="200" message="High School Required"
bind="{roster.dataProvider[roster.selectedIndex]['hs']}"
onChange="roster.dataProvider.editField(roster.sel ectedIndex, 'hs',
hs.text);">

</cfformgroup>

</cfformgroup>

</cfform>