Professional Web Applications Themes

Webshop product sorting advice? - Dreamweaver AppDev

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

  1. #1

    Default Webshop product sorting advice?

    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.

    btn Guest

  2. #2

    Default Re: Webshop product sorting advice?

    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" <webforumsusermacromedia.com> wrote in message
    news:d5djfc$23m$1forums.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.
    >

    Paul Whitham TMM Guest

Similar Threads

  1. Sorting array vs sorting paginated array
    By limitedwave777 in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: May 14th, 01:58 PM
  2. Who build the best webshop extension solution?
    By siegler in forum Adobe Dreamweaver & Contribute
    Replies: 11
    Last Post: December 19th, 11:28 PM
  3. Product rating for webshop - Average??
    By btn in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 11th, 12:11 AM
  4. Product activation when you've lost your Product ID sticker
    By larry samuels MS-MVP \(XP Shell/User\) in forum Windows XP/2000/ME
    Replies: 2
    Last Post: July 5th, 10:38 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139