A simple Drill down example using NWIND
The following is a simple drill down example ->
<%
Response.write("form=" & request.form("aspDBGridSelectBoxItem_1"))
Set x = Server.CreateObject("ASP.db")
SQL="SELECT OrderID FROM ORDERS ORDER BY OrderID"
with x
.dbUnit = 1
.dbmdb = "NWIND.mdb"
.dbSQL = SQL
.dbMode = "grid"
.dbGridInc = 99999
.dbStatusBar="false"
.dbSelectBox = "1,Order ID,Select"
.aspdb
end with
%>
<%
reqf = request.form("aspDBGridSelectBoxItem_1")
if reqf <> "" then
arr = Split(reqf,"::")
arr(0) = Trim(arr(0))
response.write("<BR>reqf=" & arr(0))
Set y=Server.CreateObject("ASP.db")
SQL="SELECT * FROM [ORDER DETAILS] WHERE ORDERID = " & arr(0)
with y
.dbDSN = "NWIND"
.dbUnit=99
.dbMode="grid"
.dbSQL=SQL
.dbGridInc= 999999
.dbGridTableTag="Border=1"
.dbNavigationItem="none"
.dbstatusbar=false
.ASPdb
end with
end if
%>