Webshop product sorting advice?

[btn]

Hi - using ASP/Access/VBscript

Need an advice on a product sorting issue for a webshop.
Have seen that different webshops has different ways to catalog products.
Some uses numbers with number fields in the DB , some uses text with text
fields in the DB

Like this example;
1. (numbers)
product.asp?Maincategory=3&Subcat=34

OR

2. (text)
product.asp?Maincategory=guitars&Subcat=Fender

What option is the best and what should i choose? (Advantages/Disadvantages) ?

Thanx.

Bjorn.

[Paul Whitham TMM]

Those that are using numbers have probably defined their categories in
separate tables which is the recommended design concept. Those that use
names have not.

The advantage of one over the other is that it makes it easier to maintain
the data and make golobal changes

--
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]

"btn" <webforumsuser@macromedia.com> wrote in message
news:d5djfc$23m$1@forums.macromedia.com...

> Hi - using ASP/Access/VBscript
>
> Need an advice on a product sorting issue for a webshop.
> Have seen that different webshops has different ways to catalog products.
> Some uses numbers with number fields in the DB , some uses text with text
> fields in the DB
>
> Like this example;
> 1. (numbers)
> product.asp?Maincategory=3&Subcat=34
>
> OR
>
> 2. (text)
> product.asp?Maincategory=guitars&Subcat=Fender
>
> What option is the best and what should i choose?

(Advantages/Disadvantages) ?

>
> Thanx.
>
> Bjorn.
>