running scrip after the page is rendered.

Giganews Newsgroups
Subject: running scrip after the page is rendered.
Posted by:  Ed (eyou…@ncsa.uiuc.edu)
Date: Fri, 18 Jul 2003

Don't know where else to ask this question...AFS people tell me they
can't answer JavaScript questions...it's a little of both with vbscript
mixed in.

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>
<head>
function addacc(num) {
var del1 = document.getElementById(num)
var stuff;
var arow = num * (-1);
document.RFO.arow.value=arow;
document.all.AccAmt.style.visibility="visible";
document.all.AccTot.style.visibility="visible";
document.RFO.acc_tot_1.value="Balance";
document.RFO.acc_tot_1.disabled="true";

stuff = "<select name=\"fund_1\" class=\"regSoft\">";
stuff = stuff + "<% Do until rs2.eof %>";
stuff = stuff + "<option><%=rs2(\"Fund\")%></option>";
stuff = stuff + "<% rs2.MoveNext";
stuff = stuff + "Loop %>";
stuff = stuff + "</select>";

num = num - 1;

stuff = stuff + "<div id=\"" + num + "\" style=\"visibilty:visible\">"
stuff = stuff + "<A onClick=\"javascript:addacc(" + num +")\"><u
class=\"regSoft\"><font color=\"blue\">Add Account</font></u></a></div>"
del1.innerHTML = stuff
}
</head>
<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"><font
color="blue">Add Account</font></u></a> </div>

Replies