DB Pulldown

I have the following that I am using in an ASP page that pulls a name
from recordset.

Response.Write "<tr>"
Response.Write "<td align=right><b>Drywall Foreman<b></td>"
Response.Write "<td valign=middle align=left><input type=text size=30
name=FM value='" & objRecordset("jfman") & "'></td>"
Response.Write "</tr>"

How can I go about creating a drop down list that populated from a
seperate table in the database and when the page is first displayed
brings up the value of the recordset like it is currently doing?

View Replies


ADVERTISEMENT

Retain Value Of Pulldown List

I have one .asp page with a SELECT pulldown list on it and some INPUT fields. When SUBMIT is clicked the form data is submitted to that same page and validated. If INPUT fields are empty the asp code will insert a visual indicator (e.g. *) to convey that the field must be filled in.

However, if the user has made a selection in the pulldown list and has left an INPUT field empty, when the form reappears after validation, the pulldown menu looses its selection and returns to its default value.Would anyone be able to provide a solution to this?Or do you need to see the code first?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved