View Single Post
  #1 (permalink)  
Old September 28th, 2004, 01:48 PM
realgone_ realgone_ is offline
Authorized User
 
Join Date: Sep 2004
Location: , , .
Posts: 22
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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.

Reply With Quote