By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,287 Members | 1,561 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,287 IT Pros & Developers. It's quick & easy.

running scrip after the page is rendered.

P: n/a
Ed
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>

Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Maybe you can have a look at thread: Frames, windows, functions & onload

Basically allows actions to take place AFTER a page has rendered.

Cheers,
Fermin DCG

Ed wrote:
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>


Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.