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".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