Results 1 to 3 of 3

Thread: Drill Down

  1. #1
    Stuart Paice Guest

    Drill Down


    i have created a drill down like the one on
    http://208.196.181.86/apps/mh-drill-down.asp
    and with mine the second drill down does not load all the values if the previous load from the first drill down had fewer values. I think that the second window is holding a record count and that is why it only shows a few values. how can i get this to refresh so that all the values are loaded in the second window

    my code looks like this

    <%
    Set MyDb = Server.CreateObject(&#34;ASP.db&#34
    Mydb.dbDBType=&#34;SQL&#34;

    MyDb.dbQuickProps = &#34;10271;W#;SR#;Grid;;;;SQL;100&#34;
    MyDb.dbNavigationItem=&#34;none&#34;
    MyDb.dbstatusbar=false
    MyDb.dbSQL=&#34;SELECT DISTINCT c# FROM sr#$&#34;
    MyDb.dbSelectBox=&#34;10,<B>Client Name</B>, Select Employee; #client#&#34;
    MyDb.dbColor = &#34;2&#34;
    MyDb.dbGridTableTag = &#34;Border=1&#34;
    MyDb.dbExportFlds=&#34;client&#34;

    &#39;MyDb.dbReset(10272)

    MyDb.ASPdb
    %>
    </TD>

    <TD valign=&#34;middle&#34; align=&#34;center&#34;>

    <%
    Set MyDb=Server.CreateObject(&#34;ASP.db&#34

    &#39;CLIENTLIST = session(&#34;ASPDB_10271_client&#34
    &#39;CL = Request(&#34;CLIENTLIST&#34
    &#39;If CL <> &#34;CLIENTLIST&#34; then
    &#39; MyDb.dbReset(10272)
    &#39; Session(&#34;CL&#34 = CLIENTLIST
    &#39;End If

    CL = session(&#34;ASPDB_10271_client&#34

    Mydb.dbDBType=&#34;SQL&#34;
    Mydb.dbdat=&#34;%%%%%%%%%%%%%%%
    MyDb.dbDSN=&#34;%%%%%%%%%%%%%%&#34;
    MyDb.dbUnit=10272
    MyDb.dbMode=&#34;grid&#34;

    sq = &#34;Select DISTINCT a# FROM SR# WHERE client = &#39;&#34;
    sq = sq & CL
    sq = sq & &#34;&#39; ORDER BY a#&#34;
    MyDb.dbSQL=sq

    MyDb.dbSelectBox=&#34;10,<B>Activity</B>, Select Activity; #activity#&#34;
    MyDb.dbGridInc=100
    MyDb.dbGridTableTag=&#34;Border=1&#34;
    MyDb.dbNavigationItem=&#34;none&#34;
    MyDb.dbExportFlds=&#34;activity&#34;
    MyDb.dbstatusbar=false
    MyDb.dbColor = &#34;2&#34;
    MyDb.dbFormTableTag = &#34;Border=1&#34;
    MyDb.ASPdb
    %>


    as you can see i have tried a few thing but these reset drill down window 2 and so the wrong value is selected

    if anyone can help i would apriciate it

    thanks Stuart

  2. #2
    Frank Kwong Guest

    Drill Down (reply)

    Always try to use a different Object variable for different modules like -

    X.Property and Y.Property and not Mydb all the way !

    FK


    ------------
    Stuart Paice at 3/23/01 12:10:03 AM


    i have created a drill down like the one on
    http://208.196.181.86/apps/mh-drill-down.asp
    and with mine the second drill down does not load all the values if the previous load from the first drill down had fewer values. I think that the second window is holding a record count and that is why it only shows a few values. how can i get this to refresh so that all the values are loaded in the second window

    my code looks like this

    <%
    Set MyDb = Server.CreateObject(&#34;ASP.db&#34
    Mydb.dbDBType=&#34;SQL&#34;

    MyDb.dbQuickProps = &#34;10271;W#;SR#;Grid;;;;SQL;100&#34;
    MyDb.dbNavigationItem=&#34;none&#34;
    MyDb.dbstatusbar=false
    MyDb.dbSQL=&#34;SELECT DISTINCT c# FROM sr#$&#34;
    MyDb.dbSelectBox=&#34;10,<B>Client Name</B>, Select Employee; #client#&#34;
    MyDb.dbColor = &#34;2&#34;
    MyDb.dbGridTableTag = &#34;Border=1&#34;
    MyDb.dbExportFlds=&#34;client&#34;

    &#39;MyDb.dbReset(10272)

    MyDb.ASPdb
    %>
    </TD>

    <TD valign=&#34;middle&#34; align=&#34;center&#34;>

    <%
    Set MyDb=Server.CreateObject(&#34;ASP.db&#34

    &#39;CLIENTLIST = session(&#34;ASPDB_10271_client&#34
    &#39;CL = Request(&#34;CLIENTLIST&#34
    &#39;If CL <> &#34;CLIENTLIST&#34; then
    &#39; MyDb.dbReset(10272)
    &#39; Session(&#34;CL&#34 = CLIENTLIST
    &#39;End If

    CL = session(&#34;ASPDB_10271_client&#34

    Mydb.dbDBType=&#34;SQL&#34;
    Mydb.dbdat=&#34;%%%%%%%%%%%%%%%
    MyDb.dbDSN=&#34;%%%%%%%%%%%%%%&#34;
    MyDb.dbUnit=10272
    MyDb.dbMode=&#34;grid&#34;

    sq = &#34;Select DISTINCT a# FROM SR# WHERE client = &#39;&#34;
    sq = sq & CL
    sq = sq & &#34;&#39; ORDER BY a#&#34;
    MyDb.dbSQL=sq

    MyDb.dbSelectBox=&#34;10,<B>Activity</B>, Select Activity; #activity#&#34;
    MyDb.dbGridInc=100
    MyDb.dbGridTableTag=&#34;Border=1&#34;
    MyDb.dbNavigationItem=&#34;none&#34;
    MyDb.dbExportFlds=&#34;activity&#34;
    MyDb.dbstatusbar=false
    MyDb.dbColor = &#34;2&#34;
    MyDb.dbFormTableTag = &#34;Border=1&#34;
    MyDb.ASPdb
    %>


    as you can see i have tried a few thing but these reset drill down window 2 and so the wrong value is selected

    if anyone can help i would apriciate it

    thanks Stuart

  3. #3
    Mark Guest

    Drill Down (reply)

    Hi Stuart,

    The rule is this:

    &#34;You MUST do a dbReset when and only when your SQL changes (usually due to a variable in your WHERE clause).&#34;


    It looks like you started to code that but it is now all commented out. You need to get that logic working. That will take care of your problems.

    Mark.




    ------------
    Stuart Paice at 3/23/01 12:10:03 AM


    i have created a drill down like the one on
    http://208.196.181.86/apps/mh-drill-down.asp
    and with mine the second drill down does not load all the values if the previous load from the first drill down had fewer values. I think that the second window is holding a record count and that is why it only shows a few values. how can i get this to refresh so that all the values are loaded in the second window

    my code looks like this

    <%
    Set MyDb = Server.CreateObject(&#34;ASP.db&#34
    Mydb.dbDBType=&#34;SQL&#34;

    MyDb.dbQuickProps = &#34;10271;W#;SR#;Grid;;;;SQL;100&#34;
    MyDb.dbNavigationItem=&#34;none&#34;
    MyDb.dbstatusbar=false
    MyDb.dbSQL=&#34;SELECT DISTINCT c# FROM sr#$&#34;
    MyDb.dbSelectBox=&#34;10,<B>Client Name</B>, Select Employee; #client#&#34;
    MyDb.dbColor = &#34;2&#34;
    MyDb.dbGridTableTag = &#34;Border=1&#34;
    MyDb.dbExportFlds=&#34;client&#34;

    &#39;MyDb.dbReset(10272)

    MyDb.ASPdb
    %>
    </TD>

    <TD valign=&#34;middle&#34; align=&#34;center&#34;>

    <%
    Set MyDb=Server.CreateObject(&#34;ASP.db&#34

    &#39;CLIENTLIST = session(&#34;ASPDB_10271_client&#34
    &#39;CL = Request(&#34;CLIENTLIST&#34
    &#39;If CL <> &#34;CLIENTLIST&#34; then
    &#39; MyDb.dbReset(10272)
    &#39; Session(&#34;CL&#34 = CLIENTLIST
    &#39;End If

    CL = session(&#34;ASPDB_10271_client&#34

    Mydb.dbDBType=&#34;SQL&#34;
    Mydb.dbdat=&#34;%%%%%%%%%%%%%%%
    MyDb.dbDSN=&#34;%%%%%%%%%%%%%%&#34;
    MyDb.dbUnit=10272
    MyDb.dbMode=&#34;grid&#34;

    sq = &#34;Select DISTINCT a# FROM SR# WHERE client = &#39;&#34;
    sq = sq & CL
    sq = sq & &#34;&#39; ORDER BY a#&#34;
    MyDb.dbSQL=sq

    MyDb.dbSelectBox=&#34;10,<B>Activity</B>, Select Activity; #activity#&#34;
    MyDb.dbGridInc=100
    MyDb.dbGridTableTag=&#34;Border=1&#34;
    MyDb.dbNavigationItem=&#34;none&#34;
    MyDb.dbExportFlds=&#34;activity&#34;
    MyDb.dbstatusbar=false
    MyDb.dbColor = &#34;2&#34;
    MyDb.dbFormTableTag = &#34;Border=1&#34;
    MyDb.ASPdb
    %>


    as you can see i have tried a few thing but these reset drill down window 2 and so the wrong value is selected

    if anyone can help i would apriciate it

    thanks Stuart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •