Re: Counting Inventory

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48864
interpreted = N
texte = You could do something like:[search products.db&eqBRANDdatarq=[brand]] This brand has: [numfound] items in the inventory. [/search] On Monday, March 24, 2003, at 12:41 PM, Alan White wrote:> 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_INVENTORY > > The 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 > > Alan > > on 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/ > ------------------------------------------------------------- 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)
You could do something like:[search products.db&eqBRANDdatarq=[brand]] This brand has: [numfound] items in the inventory. [/search] On Monday, March 24, 2003, at 12:41 PM, Alan White wrote:> 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_INVENTORY > > The 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 > > Alan > > on 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/ > ------------------------------------------------------------- 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/ Charles Kline

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:

WC2.0 Memory Requirements (1997) same products but different (1998) [ModDate] & [ModTime] ? (1997) The code, one more time. (2003) Pop-up Menu (1998) Make sure I understand this??? (1997) syntax question, not in online refernce (1997) Sorting error (1997) Authorize.net questions ... (2003) Appending with +1 ... (1997) Snake Bites (1997) Re:Variable Math (1998) Sum of [founditems] ? (2004) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) WebCatalog can't find database (1997) WebCatalog Work (2001) TemplateCacheSize preference (1998) [WebDNA] Innovative Merchant Solutions (2008) lookups or math? (1998) Conditional searching & displaying (1997)