Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dynamic drop downs and field type

Status
Not open for further replies.

realhorrorshow

Technical User
Apr 24, 2001
24
0
0
GB
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=&quot;JobNo&quot;>
<%
While (NOT rsJobNo.EOF)
%>
<option value=&quot;<%=(rsJobNo.Fields.Item(&quot;JobNo&quot;).Value)%>&quot; <% if
((rsJobNo.Fields.Item(&quot;JobNo&quot;).Value)=(rsTimeSheet.Fields.Item(&quot;JobNo&quot;).Value))
Then Response.Write(&quot;SELECTED&quot;)
%>><%=(rsJobNo.Fields.Item(&quot;JobNo&quot;).Value)%>.
<%=(rsJobNo.Fields.Item(&quot;Title&quot;).Value)%></option>
<%
rsJobNo.MoveNext()
Wend
If (rsJobNo.CursorType > 0) Then
rsJobNo.MoveFirst
Else
rsJobNo.Requery
End If
%>
</select>

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top