As discussed earlier
in
Query with Hyperlink, you can search or customize a
page based on a hyperlink.
You can also perform a similar function using the value
returned from a DRW query.
The theory is the
same, but this time, instead of you manually typing the
query parameters into a hyperlink, you use a value from
a working DRW query.
Query with
hyperlink parameters
Assuming you already have a working query DRW on an asp
page with these settings:
- The query page
name is query.asp
- You may or may
not have a search form on this page already.
- The Field name
you are searching is called ProductID
These are the steps to
follow for the new page:
- Insert a DRW
- Right click on
the field value you wish to use as the search
parameter

In this case we are selecting the field "ProductID"
from the ever useful Northwinds sample database
- From the right
click menu, select "Hyperlink"
- Select the name
of the page you will send the query to.
In this case its called 'query.asp' (single click
to select, don't double click)
- Click the button
called 'Parameters'
- Click once after
the
query.asp
to remove the selection
Now the 'Insert Field Value' button will become
available
- Your screen now
looks like this:

- Click the 'Add'
button to add a new Querystring

- Click OK
- Click OK again
You will now notice
your URL looks like this:
query.asp?ProductID=<%=FP_FieldURL(fp_rs,"ProductID")%>
Now when you click on
this link in your browser, the records of this type
only should be displayed.
For unique records you
will use the 'Auto number ID' column. (In this case
ProductID is our primary key)
For different types of records, you can use any column
/ data type.
Advanced
Try these ideas too.
- Submit your
results to the same page.
To save producing too many pages, there is no
reason the DRW cannot submit to itself.
- You could use
more criteria with an "OR" statement to search on
more than 1 column.
- At Step 3 of the
DRW, under the criteria button, you can change the
name of the parameter you are using.
ie. Instead of "ProductID", you could name it
"Bob"
Your querystring would look like this :
query.asp?Bob='<%=FP_FieldLink(fp_rs,"ProductID")%>