How to access a nested function from another nested function in javascript?

ASP code inside a JavaScript function?

• PLEASE help me fill in the question marks below. I need to look up a value from an Access database based on the value selected in a drop down box on a webpage. The onChange() triggers the function given below but as you can see the ???? indicate values I need help with. <script language ="JavaScript"> function budgetChange(dropdown) { var myindex = dropdown.selectedIndex var SelValue = dropdown.options[myindex].value <% Dim rsNew,connNew,SQLQueryNew,connStr, UL set connNew=server.createobject("ADODB.Conne… set rsNew = Server.CreateObject("ADODB.Recordset") connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Persis… Security Info=False;Data Source=" connStr = connStr + server.MapPath("orders.mdb") connNew.open connStr SQLQueryNew = "select UpperLimit from budgetLineMaster where BLAccount = ???? set rsNew=connNew.execute(SQLQueryNew) Do While Not rsNew.EOF UL = rsNew("UpperLimit") rsNew.MoveNext Loop %> document.form1.moneyLeft.value = ????

• Answer:

  This can't be done. ASP is processed on the server-side before the user ever gets a chance to change the dropdown menu. You'll have to make a form which submits the dropdown value to this or another ASP document to access the database.