Hyperlink in 2K DRW

[JA]

Hi,

I am using FrontPage 2000. I want make lists of products, sorted
alphabetically by name. Each product would link to the database by the
product number.

Ex: <a href="http://www.mysite.com/productID=[IDnumber]">Name of Product</a>

But it should only show the Product Name as a link.

Is there a way to do this using the drw, other than by writing the whole
expression out in a query in the database? I tried inserting html before and
after the product name (on the drw page), but the resulting link has
<<IDnumber>> instead of the actual number.

I hope this makes sense!

Thanks for any ideas.

JA

 

[Kathleen Anderson [MVP - FP]]

JA:
I think you want to follow this tutorial as a starting point:
http://www.spiderwebwoman.com/tutorials/picklist.htm

When you get to Step 5, do this instead:

Step 5: Display all records together and click Finish
In Normal View, right-click on <<ProductName>> in the Database Results
Region, choose Hyperlink.

In the Create Hyperlink dialog box, choose display.asp, then click
Parameters, Add, click in the Path box, Insert Field Value, choose IDnumber
from the dropdown list.

Click OK twice.

Save the page (as picklist.asp).

 

[JA]

Thanks Kathleen,

I went ahead and made the query. I was afraid it would put to much pull on the database, but the pages are loading just fine.

Another question - is it possible to sort the Product Names by subcategory and display the subcat heading somehow, using the DRW? Like this:

Subcat 1(as bookmark)
Product One
Product Two
Product Three

Subcat 2 (as bookmark)
Product One
Product Two
Product Three

etc.

I know I could sort by Subcategories, but is there a way to get the subcat heading in there?

The bookmark is so that I could put the subcategories at the head of the page, and link them to their products.

Thanks again, JA

JA:
I think you want to follow this tutorial as a starting point:
http://www.spiderwebwoman.com/tutorials/picklist.htm

When you get to Step 5, do this instead:

Step 5: Display all records together and click Finish
In Normal View, right-click on <<ProductName>> in the Database Results
Region, choose Hyperlink.

In the Create Hyperlink dialog box, choose display.asp, then click
Parameters, Add, click in the Path box, Insert Field Value, choose IDnumber
from the dropdown list.

Click OK twice.

Save the page (as picklist.asp).



--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Hi,

I am using FrontPage 2000. I want make lists of products, sorted
alphabetically by name. Each product would link to the database by the
product number.

Ex: <a href="http://www.mysite.com/productID=[IDnumber]">Name of
Product</a>

But it should only show the Product Name as a link.

Is there a way to do this using the drw, other than by writing the
whole expression out in a query in the database? I tried inserting
html before and after the product name (on the drw page), but the
resulting link has <<IDnumber>> instead of the actual number.

I hope this makes sense!

Thanks for any ideas.

JA

 

[Kathleen Anderson [MVP - FrontPage]]

You could try this: http://www.outfront.net/spooky/adv_grouping.htm

--

~ Kathleen Anderson
Microsoft FrontPage MVP
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Thanks Kathleen,

I went ahead and made the query. I was afraid it would put to much
pull on the database, but the pages are loading just fine.

Another question - is it possible to sort the Product Names by
subcategory and display the subcat heading somehow, using the DRW?
Like this:

Subcat 1(as bookmark)
Product One
Product Two
Product Three

Subcat 2 (as bookmark)
Product One
Product Two
Product Three

etc.

I know I could sort by Subcategories, but is there a way to get the
subcat heading in there?

The bookmark is so that I could put the subcategories at the head of
the page, and link them to their products.

Thanks again, JA

JA:
I think you want to follow this tutorial as a starting point:
http://www.spiderwebwoman.com/tutorials/picklist.htm

When you get to Step 5, do this instead:

Step 5: Display all records together and click Finish
In Normal View, right-click on <<ProductName>> in the Database
Results
Region, choose Hyperlink.

In the Create Hyperlink dialog box, choose display.asp, then click
Parameters, Add, click in the Path box, Insert Field Value, choose
IDnumber
from the dropdown list.

Click OK twice.

Save the page (as picklist.asp).



--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

Hi,

I am using FrontPage 2000. I want make lists of products, sorted
alphabetically by name. Each product would link to the database by
the
product number.

Ex: <a href="http://www.mysite.com/productID=[IDnumber]">Name of
Product</a>

But it should only show the Product Name as a link.

Is there a way to do this using the drw, other than by writing the
whole expression out in a query in the database? I tried inserting
html before and after the product name (on the drw page), but the
resulting link has <<IDnumber>> instead of the actual number.

I hope this makes sense!

Thanks for any ideas.

JA