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 CATEGORYALT_CATEGORY WEIGHT_CATEGORY SHIPPING_ZONE FEATURE_IMG THUMB_IMGSMALL_IMG BIG_IMAGE SIZES COLOURS NO_INVENTORYThe BRAND has a numerical value that is taken from a brands.db that storesvarious brand specific information. For example adidas might have the valueof 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:
Here is a sample of the products.db that we use:-ID SKU PRICE TITLE DESCRIPTION BRAND CATEGORYALT_CATEGORY WEIGHT_CATEGORY SHIPPING_ZONE FEATURE_IMG THUMB_IMGSMALL_IMG BIG_IMAGE SIZES COLOURS NO_INVENTORYThe BRAND has a numerical value that is taken from a brands.db that storesvarious brand specific information. For example adidas might have the valueof 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)