2. ASPRunnerPro General questions
  3. Master-Detail with other framed detail page
This topic is locked

Master-Detail with other framed detail page

 		12/12/2007 6:15:12 AM
ASPRunnerPro General questions
M
 MarkH author

I would very much appreciate help on code to write to Visual Editor to solve my dilema. I am very poor yet in my coding skills.

The scenario is a normal set of master-detail pages. I have set up a iframe on the detail page which shows another detail _list page of that same master one.
It works but shows all records. I would like it to show only the records based on the masterkey.
Appart from the code itself, please confirm if I should set up a master-detail relationship between the master and this second detail table.
I´ll accept any other suggestion.
Thanks so much in advance,
Mark
M
 		MarkH author 12/13/2007

What´s behind this is the idea of pulling together a dashboard...I am open to suggestions...
Sergey Kornilov admin 12/13/2007

Probably you can use SESSION("FirstDetailTableName_masterkey1") variable to get the master key values and adjust SQL query of the second table.
Use BeforeSQLQuery event for this purpose.
M
 		MarkH author 12/13/2007

The session variable is exactly what I needed and worked fine (verified using response.write).

My current SQL query is as follows:
select [OrderID],

[PurchaseDate],

[ClientID],

[VendorID]

From [Orders]
and SESSION("FirstDetailTableName_masterkey1") provides the ClientID.
What do I write in the BeforeSQLQuery event to modify current SQL query?
Thanks so far. So far, so good.
M
 		MarkH author 12/15/2007

I imagine this is quite simple, and I´ve done so weell so far using AspRunner...this is basically what´s missing to finsh my task..I would really appreciate if someone could kindly help...Thanks,

MarkH
Sergey Kornilov admin 12/15/2007

Something like this will work:

strWhereClause = " ClientID = " & SESSION("FirstDetailTableName_masterkey1")
M
 		MarkH author 12/16/2007

Something like this will work:

strWhereClause = " ClientID = " & SESSION("FirstDetailTableName_masterkey1")


Thanks so much...worked fine...