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("ASP.db"
Mydb.dbDBType="SQL"
MyDb.dbQuickProps = "10271;W#;SR#;Grid;;;;SQL;100"
MyDb.dbNavigationItem="none"
MyDb.dbstatusbar=false
MyDb.dbSQL="SELECT DISTINCT c# FROM sr#$"
MyDb.dbSelectBox="10,<B>Client Name</B>, Select Employee; #client#"
MyDb.dbColor = "2"
MyDb.dbGridTableTag = "Border=1"
MyDb.dbExportFlds="client"
'MyDb.dbReset(10272)
MyDb.ASPdb
%>
</TD>
<TD valign="middle" align="center">
<%
Set MyDb=Server.CreateObject("ASP.db"
'CLIENTLIST = session("ASPDB_10271_client"
'CL = Request("CLIENTLIST"
'If CL <> "CLIENTLIST" then
' MyDb.dbReset(10272)
' Session("CL" = CLIENTLIST
'End If
CL = session("ASPDB_10271_client"
Mydb.dbDBType="SQL"
Mydb.dbdat="%%%%%%%%%%%%%%%
MyDb.dbDSN="%%%%%%%%%%%%%%"
MyDb.dbUnit=10272
MyDb.dbMode="grid"
sq = "Select DISTINCT a# FROM SR# WHERE client = '"
sq = sq & CL
sq = sq & "' ORDER BY a#"
MyDb.dbSQL=sq
MyDb.dbSelectBox="10,<B>Activity</B>, Select Activity; #activity#"
MyDb.dbGridInc=100
MyDb.dbGridTableTag="Border=1"
MyDb.dbNavigationItem="none"
MyDb.dbExportFlds="activity"
MyDb.dbstatusbar=false
MyDb.dbColor = "2"
MyDb.dbFormTableTag = "Border=1"
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