I have a series of select statements such as this one that gets it's options from our database. At the end of the select statment(s) is a script to create another row of select statements so a person needing more than one account to process an order can do just that. Problem is I can't run the sql script again after they click the "Add Account" so I'm stuck just offering them a text boxes instead of select statements for each additional Account they want to add...anyone know a way around this?
I need to build a select statment from a sql statement after the page has been rendered.
sSQL2 = "SELECT DISTINCT Fund" & _
" FROM MasterTableCfoapal2"
set rs2 = Connect2.Execute(sSQL2)
<html><body>
<select name="fund_1" class="regSoft">
<% Do until rs2.eof %>
<option><%=rs2("Fund")%></option>
<% rs2.MoveNext
Loop %>
</select>
<div id="-2" style="visibility:visible">
<a onClick=javascript
:addacc(-2)><u class="regSoft">Add Account</u></a> </div>
using sql infromation after page has been rendered
