I steal from colleagues and now I shamelessly steal from partners. This is a good example of coding the properties of a Search Select Advanced field in an ASP page.
The most important thing to point out is that this shows how to use the search sql property.
EditBlock=eWare.GetBlock("FulfillmentOneNewEntry");
with (EditBlock)
{
GetEntry("fulf_contractidone").Caption = "Contract";
GetEntry("fulf_contractidone").SearchSQL = "cont_companyid = " + compID;
GetEntry("fulf_productofferingidone").Caption = "Product Offering";
GetEntry("fulf_productofferingidone").Restrictor = "fulf_contractidone";
}
The most important thing to point out is that this shows how to use the search sql property.
EditBlock=eWare.GetBlock("FulfillmentOneNewEntry");
with (EditBlock)
{
GetEntry("fulf_contractidone").Caption = "Contract";
GetEntry("fulf_contractidone").SearchSQL = "cont_companyid = " + compID;
GetEntry("fulf_productofferingidone").Caption = "Product Offering";
GetEntry("fulf_productofferingidone").Restrictor = "fulf_contractidone";
}