Re: Need Advice for Setting up a Database

This WebDNA talk-list message is from

1999


It keeps the original formatting.
numero = 25664
interpreted = N
texte = > > > >I am working on a site and need some advice on the best way to set up the > > >database. I have various products (jackets, shirts, etc.) that come in > > >various sizes and various colors. The problem I am running into is the >best > > >way to set it up for varying prices depending on the price. > > > > > >XXX-L and XXXX-L shirts have an automatic price increase. How would you >set > > >up a database to feature this information?Another technique is to set up a second relational table and use it to store the different prices. The storebuilder does this, it might be worth it for you to take a look at those templates too. Your db might look something like this:SKU MEASURE PRICE 01 1 5 01 2 6 01 3 7 02 1 8 02 2 9 02 3 10You can now use the SKU from the products.db to search this second relational table to get the right price for the SKU and MEASURE. Remember that when you are changing the price of an item after it has been added to the cart you must use the price change password.---------------- Technical Support Smith Micro, Internet Solutions Division Formerly Pacific Coast Software --------------------------------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Associated Messages, from the most recent to the oldest:

    
  1. Re: Need Advice for Setting up a Database (Smith Micro Support 1999)
  2. Re: Need Advice for Setting up a Database (Brady J. Horenstein 1999)
  3. Re: Need Advice for Setting up a Database (The Mooseman 1999)
  4. Need Advice for Setting up a Database (Brady J. Horenstein 1999)
> > > >I am working on a site and need some advice on the best way to set up the > > >database. I have various products (jackets, shirts, etc.) that come in > > >various sizes and various colors. The problem I am running into is the >best > > >way to set it up for varying prices depending on the price. > > > > > >XXX-L and XXXX-L shirts have an automatic price increase. How would you >set > > >up a database to feature this information?Another technique is to set up a second relational table and use it to store the different prices. The storebuilder does this, it might be worth it for you to take a look at those templates too. Your db might look something like this:SKU MEASURE PRICE 01 1 5 01 2 6 01 3 7 02 1 8 02 2 9 02 3 10You can now use the SKU from the products.db to search this second relational table to get the right price for the SKU and MEASURE. Remember that when you are changing the price of an item after it has been added to the cart you must use the price change password.---------------- Technical Support Smith Micro, Internet Solutions Division Formerly Pacific Coast Software --------------------------------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Smith Micro Support

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

[WebDNA] table comma field delimiter bug? (2012) WebMerchant and PC Auth Hub (1999) WebCat2: Items xx to xx shown, etc. (1997) ShowNext (1997) [input]?? (1998) Webdna keeps dying... (2003) Dummy Credit Card Number for debug? (1997) Calculating Shipping charges for multiple items andqtys > 1 (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) Single Link browsing (1997) How to append text after the sign & (1997) PCS Frames-Default page is solution! (1997) No comment (1997) Location of Browser Info.txt file (1997) RAM variables (1997) Default contains WEBDNA (1998) ReturnRaw context (1997) Search context not finding recent entries (1998) wrong authentication (1998) [cart] how is it generated (2002)