Updating Records in db using select boxes
I have an intranet site where I provide a screen for
engineers to update information. The updatable fields are text boxes like this:
<Input Type="text" name="eTransit1" value="<%=Server.HTMLEncode(rsUpdate.Fields("EastC oastPort1").Value)%>
A need has arisen to provide select boxes in place of these text boxes. I have tried for example:
<select name="EastCoastPort1">
<option value="">All</option>
<option value="<%=Server.HTMLEncode(rsUpdate.Fields("EastC oastPort1").Value)%>" Selected>New York</option>
<option value="<%=Server.HTMLEncode(rsUpdate.Fields("EastC oastPort1").Value)%>" Selected>New Jersey</option>
</select>
but obviously doesn;t work. I want to provide a listing here which will point to the saved value but can also be modified and updated to something else.
Thanks.
|