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:

New Command prefs ... (1997) WebCatalog2 Feature Feedback (1996) Does not begin with.... (2003) problems with 2 tags (1997) Almost a there but..bye bye NetCloak (1997) WebCatalog for Postcards ? (1997) Signal Raised Error (1997) sort problems....bug or brain fart? (1997) japanese characters (1997) search question (2001) WebCat2b13MacPlugIn - more [date] problems (1997) OT bookmark my site (1999) [Shell] not relative (2000) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Uh...can someone help me out with the b10? (1997) two unique banners on one page (1997) Help! WebCat2 bug (1997) WebCatalog2 Feature Feedback (1996) Softball questions (2003) Formatting of email on NT (1998)