navigation
Thomas Brunt's OutFront Hosting
 
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Microsoft MVP
 

Spooky's Databases > Using Hyperlink Parameters

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")%>

  • Click OK

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")%>

Microsoft Corporation in no way endorses or is affiliated with "OutFront." 
OutFront is published and edited by Thomas Brunt
440 Great Circle Dr., St. Matthews, SC 29135.  803-655-6151
© 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006 All Rights Reserved
Click here to view our privacy statement.