p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Classic ASP Databases (http://p2p.wrox.com/forumdisplay.php?f=62)
-   -   Updating Records in db using select boxes (http://p2p.wrox.com/showthread.php?t=19108)

realgone_ September 28th, 2004 01:48 PM

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.


realgone_ September 28th, 2004 02:23 PM

Answered my own question. It wasn't working because of another problem which I overlooked. Thanks.



All times are GMT -4. The time now is 12:42 AM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.