Link to a page dependent on Field Value

[Karl Goddard]

ASP / MSSQL

Hi

I have a collectors database that stores details of various pieces of
sporting memorabilia - books, medals, trophies etc. I've created a view that
pulls all items that were manufactured, published or issued by the same
company.

I've created a simple page that lists the results from this view. The
problem I'm facing is when I try and create a 'details page' for the items.

As each of the item types can have different fields e.g. Books would have a
field for number pages, Trophies would have a field for engraved / not
engraved etc. I can't think of a way to have a single 'item details' page as
each item type has fields unique to that item type, unless I had multiple If
/ Thens to display relevant fields and text labels for the fields etc.

What I'd like to have is some way of having a link to a specific page
dependant on the item type e.g. if the item was a Book go to
'book_details.asp?ItemID=999' or a Trophy to 'trophy_detail.asp?ItemId=1000'

Is it possible to somehow create a 'dynamic' link dependant on the ItemType
or should I have a single details page with If / Thens?

It all sounds very confusing doesn't it, but any pointers or advice would be
most welcome!

Thanks!

[Paul Whitham TMM]

You have two choses really, namely multiple IF statements or different
pages. I think that the former is preferable.

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"Karl Goddard" <karlDOTgoddard@primary-ict.co.uk> wrote in message
news:d3t6dg$b4r$1@forums.macromedia.com...

> ASP / MSSQL
>
> Hi
>
> I have a collectors database that stores details of various pieces of
> sporting memorabilia - books, medals, trophies etc. I've created a view

that

> pulls all items that were manufactured, published or issued by the same
> company.
>
> I've created a simple page that lists the results from this view. The
> problem I'm facing is when I try and create a 'details page' for the

items.

>
> As each of the item types can have different fields e.g. Books would have

a

> field for number pages, Trophies would have a field for engraved / not
> engraved etc. I can't think of a way to have a single 'item details' page

as

> each item type has fields unique to that item type, unless I had multiple

If

> / Thens to display relevant fields and text labels for the fields etc.
>
> What I'd like to have is some way of having a link to a specific page
> dependant on the item type e.g. if the item was a Book go to
> 'book_details.asp?ItemID=999' or a Trophy to

'trophy_detail.asp?ItemId=1000'

>
> Is it possible to somehow create a 'dynamic' link dependant on the

ItemType

> or should I have a single details page with If / Thens?
>
> It all sounds very confusing doesn't it, but any pointers or advice would

be

> most welcome!
>
> Thanks!
>
>