dix
|
| Posted: 05/06/2002, 11:22 AM |
|
hello.
i've created a page in asp with grid and search. i'm doing a search on a query to bring together info from two tables in the database that have a one-to-many relationship (i.e. one organization that has many services). because of this, the query shows each organization multiple times, once for each of the services it offers. while each result returned is actually distinct, it doesn't look that way.
i figured a good way to get around this is to create two grid forms on the page, one that is attached to the query (with the apparant psuedo duplication of organizatons), and one pulling from the original table of organizations that shows each organization once. i'm looking at the show/hide forms article in the tips section of gotocode, and trying to create the asp that will show the proper form, based upon whether or not somebody enteres a paramenter for services in the search form or not, but i'm not having much luck.
how do i access the search parameters for my before show events on both grids to determine which one will be displayed? ideas appreciated.
|
|
|
 |
Nicole
|
| Posted: 05/07/2002, 5:27 AM |
|
Dix,
you should check passed parameters in form Open event, not before show.
In ASP use GetParam("param_name") to access passed value. Use it as hide condition.
E.g.
if GetParam(service_name)= "" then
SetVar "FormFormName", ""
exit sub
end if
|
|
|
|
|
