dj5md
07-19-2005, 09:01 AM
:confused:
I am not able to write the values from these select boxes to my DB.
Here is the code for the select boxes:
<td height="30">Team Ownership: </td>
<cfset TeamList = ""/>
<td>
<selectname="myTeam#myLoop#"onChange="tsrUpdSelects(this,this.form.mySubTeam#MyLoop#, this);">
<option value="" selected> Select Project Team
</option>
<cfloop query="qrygetteams">
<cfif not listFindNoCase(TeamList,qrygetteams.IssueTeamTitle,",")>
<option value="#qrygetteams.IssueTeamTitle#">
#qrygetteams.IssueTeamTitle#
</option>
<cfset TeamList = listAppend(TeamList,qrygetteams.IssueTeamTitle,",") />
</cfif>
</cfloop>
</select>
Second Select Box:
<select name="mySubTeam#myLoop#" onChange="tsrUpdSelects(CreateScenario.myTeam#myLoop#, this);">
<option value="" selected> Select Project SubTeam
</option>
</select>Text
Insert Statement:
Insert into Scenario
(ScenarioID, Scenario_Desc, Scenario, TeamOwner, TeamOwnerSub, ProcessOwner, ScriptOwner, Status)
Values
('#Session.ScenarioID#',
'#Trim(Form.Scenario_Desc)#',
'#Trim(Form.Scenario)#',
'#trim(form['myTeam' & myLoop])#',
'#trim(form['mysubTeam' & myLoop])#',
'#Trim(Form.Process)#',
'#Trim(Form.Script)#',
'#Trim(Form.Status)#')
Error Message:
Variable MYLOOP is undefined.
The error occurred in D:\Inetpub\wwwroot\Projects\TestScenario\_actions\act_CreateScenario.cfm: line 10
8 : '#Trim(Form.Scenario_Desc)#',
9 : '#Trim(Form.Scenario)#',
10 : '#trim(form['myTeam' & myLoop])#',
11 : '#trim(form['mysubTeam' & myLoop])#',
12 : '#Trim(Form.Process)#',
I am not able to write the values from these select boxes to my DB.
Here is the code for the select boxes:
<td height="30">Team Ownership: </td>
<cfset TeamList = ""/>
<td>
<selectname="myTeam#myLoop#"onChange="tsrUpdSelects(this,this.form.mySubTeam#MyLoop#, this);">
<option value="" selected> Select Project Team
</option>
<cfloop query="qrygetteams">
<cfif not listFindNoCase(TeamList,qrygetteams.IssueTeamTitle,",")>
<option value="#qrygetteams.IssueTeamTitle#">
#qrygetteams.IssueTeamTitle#
</option>
<cfset TeamList = listAppend(TeamList,qrygetteams.IssueTeamTitle,",") />
</cfif>
</cfloop>
</select>
Second Select Box:
<select name="mySubTeam#myLoop#" onChange="tsrUpdSelects(CreateScenario.myTeam#myLoop#, this);">
<option value="" selected> Select Project SubTeam
</option>
</select>Text
Insert Statement:
Insert into Scenario
(ScenarioID, Scenario_Desc, Scenario, TeamOwner, TeamOwnerSub, ProcessOwner, ScriptOwner, Status)
Values
('#Session.ScenarioID#',
'#Trim(Form.Scenario_Desc)#',
'#Trim(Form.Scenario)#',
'#trim(form['myTeam' & myLoop])#',
'#trim(form['mysubTeam' & myLoop])#',
'#Trim(Form.Process)#',
'#Trim(Form.Script)#',
'#Trim(Form.Status)#')
Error Message:
Variable MYLOOP is undefined.
The error occurred in D:\Inetpub\wwwroot\Projects\TestScenario\_actions\act_CreateScenario.cfm: line 10
8 : '#Trim(Form.Scenario_Desc)#',
9 : '#Trim(Form.Scenario)#',
10 : '#trim(form['myTeam' & myLoop])#',
11 : '#trim(form['mysubTeam' & myLoop])#',
12 : '#Trim(Form.Process)#',