Hi All,

I am trying to populate the second drop down based on selection of first dropdown value. I am facing an error at second query("select ApplicationDetail from Pega_Application_Group where ApplicationGroup='"& rst(0) &"/'"
).
The same query fetches records when run in Ms-Access database, while in the code it fetches zero records.

Please help.


<SCRIPT LANGUAGE="JavaScript">
function disp_text(form1)
        {
                ctr1 = 0;

                var programarray = new Array();
                var menuarray = new Array();
                var s1;
                <%
                ssql = "select distinct ApplicationGroup from Pega_Application_Group"
                set rst = cnx.execute(sSql)
                if not rst.eof then
                i=0
                    do while not rst.eof
                %>
                programarray[<%=i%>] = "<%=rst(0)%>";

                <%
                    dim strmenu,posval1

ssql1 ="select ApplicationDetail from Pega_Application_Group where ApplicationGroup='"& rst(0) &"/'"
                    set rrst = server.createobject("adodb.recordset")
                    rrst.open ssql1, cnx


                    strmenu = ""

                    if not rrst.eof then


                        do while not rrst.eof
                        posval1 = rrst.fields.item(0).value
                        strmenu = strmenu & "/'" & posval1 & "/'" & ","
                            rrst.movenext
                        loop
                    end if
                    %>

                        menuarray[<%=i%>] = [<%=strmenu%>];

                <%
                    i = i + 1
                    rst.movenext
                    loop
                end if
                rst.close
                set rst = nothing

                %>



                for (ctr=0; ctr < programarray.length; ctr++)
                {

                    if (form1.options[form1.selectedIndex].text == programarray[ctr])
                    {

                        ctr1 = ctr1 + 1;
                        break;
                    }
                }
                var buf2=document.appsForm.AppDetail;
                var buf2arr=buf2.options;

                if (ctr1 == 0)
                {


                    buf2arr[0].value='';
                    buf2arr[0].text='---Select---';

                }
                else
                {

                    buf2arr.length=0;
                    buf2arr.length=1;
                    buf2arr.length=menuarray[ctr].length;

                    for(i=0;i < menuarray[ctr].length-1;i++)
                    {

                        var newvar1 = menuarray[ctr][i];
                        var newvar = newvar1.split("-");
                        buf2arr[(i)].value = newvar[0];
                        buf2arr[(i)].text = newvar[1];
                    }

                }
            }

</SCRIPT>

You are committing one of the cardinal sins of ASP (or PHP or JSP or ASP.NET or...) programming: You are creating an inner recordset during a loop through an outer recordset. Your server-side performance will be horrible.

So, rather than try to wade through and fix your code, I'll just post my own version of the code to do this.

http://www.clearviewdesign.com/clear...bie/demos.html

There are two versions on that page:

Multiple drop-down lists, subcategories via ASP
and
Multiple drop-down lists, subcategories via JavaScript.

The latter matches (in effect, but not in implementation) what you are doing. But no nested loops.

&&&&&&&&&&&&&&&

I do have to ask, though, why you have the / in that code:
   " WHERE ... ApplicationGroup='"& rst(0) &"/'"
???

Do you really have slashes in your DB data? Seems like a bad idea. Normally, you would have the foreign key value in table 2 *exactly* match the primary key value in table 1.

Hello,

With reference to your code, your code submits to itself, whereas i am trying to apply these changes within the frames and the page is not submitted here.

Could you advice on this?

The " / " in that code is to avoid the error thrown by javascript when passing the string within '....' as javasciprt identifies " ' " as end of string.


Please help.

 

No, it doesn't. When you enclose a single quote in double quotes
   "'"
or a double quote in single quotes
   '"'
JavaScript behaves correctly.

But in any case, if you want to "escape" a character in JavaScript, you use a *BACKSLASH* character, not a forward slash.

And, finally, that code with the "/'" is *NOT* JavaScript! It is VBScript code. JavaScript would never *SEE* that string, at all, as it is used by your VBScript code to create a recordset on the server.

***************

Yes, my code posts back to itself. If you are talking about the
     Multiple drop-down lists, subcategories via ASP
version. But that's not the version you should have looked at. The demo titled
     Multiple drop-down lists, subcategories via JavaScript.
is the one that matches closely what you are doing.