Re: Counting Inventory

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48860
interpreted = N
texte = Here is a sample of the products.db that we use:-ID SKU PRICE TITLE DESCRIPTION BRAND CATEGORY ALT_CATEGORY WEIGHT_CATEGORY SHIPPING_ZONE FEATURE_IMG THUMB_IMG SMALL_IMG BIG_IMAGE SIZES COLOURS NO_INVENTORYThe BRAND has a numerical value that is taken from a brands.db that stores various brand specific information. For example adidas might have the value of 9...HTH Alanon 24/3/03 5:29 pm, Charles Kline at ckline@rightcode.net wrote:> Alan, > > Could you post a snippet of how you store this information? Do you have > a brand_id or something listed with each product etc.? > This way you can see an example that will work for you. > > - Charles > > On Monday, March 24, 2003, at 12:27 PM, Alan White wrote: > >> Hi >> >> Does anybody have an example of how to count the total number of >> products in >> inventory for a given brand? The reason I want to do this is so that >> I can >> then use this number to see if it is > 0 and then display a brand only >> if >> there is product available. >> >> Hope someone can help... >> >> Alan White >> ------------------------------ >> http://www.streethreds.com >> >> >> >> ------------------------------------------------------------- >> 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 >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Counting Inventory (Charles Kline 2003)
  2. Re: Counting Inventory (Alan White 2003)
  3. Re: Counting Inventory (Charles Kline 2003)
  4. Counting Inventory (Alan White 2003)
Here is a sample of the products.db that we use:-ID SKU PRICE TITLE DESCRIPTION BRAND CATEGORY ALT_CATEGORY WEIGHT_CATEGORY SHIPPING_ZONE FEATURE_IMG THUMB_IMG SMALL_IMG BIG_IMAGE SIZES COLOURS NO_INVENTORYThe BRAND has a numerical value that is taken from a brands.db that stores various brand specific information. For example adidas might have the value of 9...HTH Alanon 24/3/03 5:29 pm, Charles Kline at ckline@rightcode.net wrote:> Alan, > > Could you post a snippet of how you store this information? Do you have > a brand_id or something listed with each product etc.? > This way you can see an example that will work for you. > > - Charles > > On Monday, March 24, 2003, at 12:27 PM, Alan White wrote: > >> Hi >> >> Does anybody have an example of how to count the total number of >> products in >> inventory for a given brand? The reason I want to do this is so that >> I can >> then use this number to see if it is > 0 and then display a brand only >> if >> there is product available. >> >> Hope someone can help... >> >> Alan White >> ------------------------------ >> http://www.streethreds.com >> >> >> >> ------------------------------------------------------------- >> 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 >> >> Web Archive of this list is at: http://webdna.smithmicro.com/ >> > > > ------------------------------------------------------------- > 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 > > Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Alan White

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:

two domains and one cart and database (2000) Field Not Blank (2006) WebMerch/Emailer Error (1998) Misc Stuff That Might Help (1997) credit card services (1997) problem with text A (2000) Passwords, Subscription, DBs, oh my! (2000) eq (2000) WebCatalog 2.0.1 NT beta 1 released (1997) Ok here is a question? (1997) list archives (2004) process SSI (1998) [createfolder] & [deletefolder] (1997) dates and hex formatting (1997) error: Too many nested [xxx] contexts (1997) Multiple fields on 1 input (1997) Need relative path explanation (1997) WebCat2 - [SendNews] (1997) Search returns all, not 20 (1997) Server replication (1998)