Added: December/06/2004 at 2:23pm | IP Logged

I use the following code to read a db table and dynamically build a html table with the data. The last field, 'dev_proj_status' should have its values read in from another table of status types.
------------------------------------------------------------
SQLstmt = "SELECT * FROM tbl_wr_Main WHERE (dev_proj_status <> 'Pending') AND (dev_developer = '"&usr_fname&" "&usr_lname&"') ORDER BY submit_date DESC"
Set RS = Conn.Execute(SQLstmt)
Do While NOT RS.EOF
%>
<tr align="center" valign="top">
<td><%=RS.Fields.Item("id").Value%></td>
<td><%=RS.Fields.Item("submit_date").Value%>< /td>
<td><%=RS.Fields.Item("proj_req_due_date").Value%&g t;</td>
<td><input name="proj_title" type="text" value="<%=RS("proj_title")%>" size="55" maxlength="255" readonly> 
  <input name="proj_url" type="text" id="proj_url" value="<%=RS("proj_url")%>" size="55" maxlength="255" readonly style="background-color:#FFFFCC;"></td>
<td><textarea name="proj_det_desc" cols="50" rows="3" readonly="yes"><%=RS("proj_det_desc")%></textare a></td>
<td><%=RS.Fields.Item("usr_fname").Value%>&n bsp;<%=RS.Fields.Item("usr_lname").Value%></td>
<td bgcolor="#FFEEDD">
<select name="dev_proj_status">
<option selected><%=RS("dev_proj_status")%></option>
</select>
</td>
</tr>
<%
RS.MoveNext
Loop
RS.Close
------------------------------------------------------
So my question is can I, within the <select> tag, read in the values of another table (which has only one field) to populate that <select> tag thus nesting these table reads within each other? I want this so the developer can change the status of the project.

Thanks for any help,
Chris
~`^%

Added: December/06/2004 at 4:43pm | IP Logged

did you read this

http://www.powerasp.com/content/code-snippets/forms-populate -drop-down-menu.asp

Added: December/06/2004 at 4:56pm | IP Logged

cwilliams,

Thank you. But, can I nest the table reads?

Chris