Forms aren't the only
way to query a database.
Now you can search or
customize a page based on a hyperlink.
A hyperlink
query looks like this:
http:/testing/query.asp?NAME=Bob
This will now link to
the page query.asp and supply a variable called NAME
with the value of Bob.
You can customize your
page to display nothing but Bob's.
Query with
hyperlink
The method to set up this query, is the same as in
Form Query
Construct your query
page using the above method. This will be the query
page you will access with your hyperlink.
On another page add
your hyperlink, linking to your query page.
- Right click on
the hyperlink
- Select
'Hyperlink'
- After the query
page address, type:
querypage.asp?FieldName=Value
Where Fieldname is equal to the name of the
field in the database you are querying.
Value is the value you wish to search on.
There are a couple of
changes you can make, for example:
Don't display a search
form on your query page:
- At step 5 of the
DRW uncheck the "Add search form"
Multiple field queries
- More than 1
query can be performed. Add more criteria in step
3 of the DRW
- After the query
page address, type:
querypage.asp?FieldName=Value&FieldName2=Value
