realhorrorshow
Technical User
with the below line of code the correct records do not become selected in the dropdown box when the field type of 'rsJobNo.Fields.Item("JobNo"
' is an integer,but it does as a varchar. this is causing problems, does anyone have a
suggestion?
<select name="JobNo">
<%
While (NOT rsJobNo.EOF)
%>
<option value="<%=(rsJobNo.Fields.Item("JobNo"
.Value)%>" <% if
((rsJobNo.Fields.Item("JobNo"
.Value)=(rsTimeSheet.Fields.Item("JobNo"
.Value))
Then Response.Write("SELECTED"
%>><%=(rsJobNo.Fields.Item("JobNo"
.Value)%>.
<%=(rsJobNo.Fields.Item("Title"
.Value)%></option>
<%
rsJobNo.MoveNext()
Wend
If (rsJobNo.CursorType > 0) Then
rsJobNo.MoveFirst
Else
rsJobNo.Requery
End If
%>
</select>
Thanks
suggestion?
<select name="JobNo">
<%
While (NOT rsJobNo.EOF)
%>
<option value="<%=(rsJobNo.Fields.Item("JobNo"
((rsJobNo.Fields.Item("JobNo"
Then Response.Write("SELECTED"
%>><%=(rsJobNo.Fields.Item("JobNo"
<%=(rsJobNo.Fields.Item("Title"
<%
rsJobNo.MoveNext()
Wend
If (rsJobNo.CursorType > 0) Then
rsJobNo.MoveFirst
Else
rsJobNo.Requery
End If
%>
</select>
Thanks