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:

[WebDNA] What is lateset ver. of Apache supported? (2008) Orders coming up blank (2004) Emailer setup (1997) WebCat2: Found Items syntax, etc. (1997) [TaxableTotal] - not working with AOL and IE (1997) WebCat2 several catalogs? (1997) Generating Report Totals (1997) Showing unopened cart (1997) Just Testing (1997) OT: Sending email to lots of subscribers (1999) WebCat Documentation (was [platform] tag?) (1998) Limit on nested [ShowIf]'s? (1997) WC2.0 Memory Requirements (1997) Summing fields (1997) Help! Strange happenings... (1997) Stopping bad HTML propagation ? (1997) [SHOWIF] (1997) WebDNA Book? (2003) When do we get to request new features? (1999) Force a search at the default.tmpl page? (1997)