I have code generated by UD4 (below).
The first batch of code works - when a selection is made that value shows up on the Update page.
The second batch of code - which seems identical - does not show the selected value on the Update page. It shows the initial value in the options list.
I have about ten drop down lists/menus on the page and only the one is not functioning as it should.
Any clues? Am I missing something blatantly obvious?
BATCH 1
<td >This Dispatch Card was Updated By:</td>
<td>
<select name="mnuUpdateBy">
<option>Please Select</option>
<%
While (NOT rsDispatch.EOF)
%>
<option value="<%=(rsDispatch.Fields.Item("Dispatch".Value)%>" <%if (CStr(rsDispatch.Fields.Item("Dispatch".Value) = CStr(rsUpdateOpen.Fields.Item("mnuUpdateBy".Value)) then Response.Write("SELECTED" : Response.Write(""%>><%=(rsDispatch.Fields.Item("Dispatch".Value)%></option>
<%
rsDispatch.MoveNext()
Wend
If (rsDispatch.CursorType > 0) Then
rsDispatch.MoveFirst
Else
rsDispatch.Requery
End If
%>
</select>
</td>
</tr>
<tr>
BATCH 2
<td>Disposition of Dispatch:</td>
<td>
<select name="mnuEventType">
<option>Unknown</option>
<%
While (NOT rsEventType.EOF)
%>
<option value="<%=(rsEventType.Fields.Item("EventType".Value)%>" <%if (CStr(rsEventType.Fields.Item("EventType".Value) = CStr(rsUpdateOpen.Fields.Item("mnuEventType".Value)) then Response.Write("SELECTED" : Response.Write(""%>><%=(rsEventType.Fields.Item("EventType".Value)%></option>
<%
rsEventType.MoveNext()
Wend
If (rsEventType.CursorType > 0) Then
rsEventType.MoveFirst
Else
rsEventType.Requery
End If
%>
</select>
</td>
The first batch of code works - when a selection is made that value shows up on the Update page.
The second batch of code - which seems identical - does not show the selected value on the Update page. It shows the initial value in the options list.
I have about ten drop down lists/menus on the page and only the one is not functioning as it should.
Any clues? Am I missing something blatantly obvious?
BATCH 1
<td >This Dispatch Card was Updated By:</td>
<td>
<select name="mnuUpdateBy">
<option>Please Select</option>
<%
While (NOT rsDispatch.EOF)
%>
<option value="<%=(rsDispatch.Fields.Item("Dispatch".Value)%>" <%if (CStr(rsDispatch.Fields.Item("Dispatch".Value) = CStr(rsUpdateOpen.Fields.Item("mnuUpdateBy".Value)) then Response.Write("SELECTED" : Response.Write(""%>><%=(rsDispatch.Fields.Item("Dispatch".Value)%></option>
<%
rsDispatch.MoveNext()
Wend
If (rsDispatch.CursorType > 0) Then
rsDispatch.MoveFirst
Else
rsDispatch.Requery
End If
%>
</select>
</td>
</tr>
<tr>
BATCH 2
<td>Disposition of Dispatch:</td>
<td>
<select name="mnuEventType">
<option>Unknown</option>
<%
While (NOT rsEventType.EOF)
%>
<option value="<%=(rsEventType.Fields.Item("EventType".Value)%>" <%if (CStr(rsEventType.Fields.Item("EventType".Value) = CStr(rsUpdateOpen.Fields.Item("mnuEventType".Value)) then Response.Write("SELECTED" : Response.Write(""%>><%=(rsEventType.Fields.Item("EventType".Value)%></option>
<%
rsEventType.MoveNext()
Wend
If (rsEventType.CursorType > 0) Then
rsEventType.MoveFirst
Else
rsEventType.Requery
End If
%>
</select>
</td>