Re: Finding unused SKU's in a database

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 44701
interpreted = N
texte = on 11/1/02 1:04 PM, Gary Krockover at gary@garykrockover.com so noted...> I think I worded this funny. Here's a dummy approach: > > db=catalog.txt > SKU > 1 > 3 > 5 > > How would I search and display that a SKU of 2 and 4 are available in the > above example?I'd do:[math show=f]lastSKU=1[/math] [search db=catalog.txt&neSKUdata=[blank]&SKUsort=1&SKUtype=num] [founditems] [showif [SKU]>[math]openSKU=[lastSKU]+1[/math]][openSKU] - [math][SKU]-1[/math]
[/showif] [math show=f]lastSKU=[SKU][/math] [/founditems] [/search]For a list like:1 3 5 6 7 8 12 18 19 26It returns the ranges of open SKUs as:2 - 2 4 - 4 9 - 11 13 - 17 20 - 25 Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Finding unused SKU's in a database (Gary Krockover 2002)
  2. Re: Finding unused SKU's in a database (Rob Marquardt 2002)
  3. Re: Finding unused SKU's in a database (Gyuri 2002)
  4. Re: Finding unused SKU's in a database (Gary Krockover 2002)
  5. Finding unused SKU's in a database (Gary Krockover 2002)
on 11/1/02 1:04 PM, Gary Krockover at gary@garykrockover.com so noted...> I think I worded this funny. Here's a dummy approach: > > db=catalog.txt > SKU > 1 > 3 > 5 > > How would I search and display that a SKU of 2 and 4 are available in the > above example?I'd do:[math show=f]lastSKU=1[/math] [search db=catalog.txt&neSKUdata=[blank]&SKUsort=1&SKUtype=num] [founditems] [showif [SKU]>[math]openSKU=[lastSKU]+1[/math]][openSKU] - [math][SKU]-1[/math]
[/showif] [math show=f]lastSKU=[SKU][/math] [/founditems] [/search]For a list like:1 3 5 6 7 8 12 18 19 26It returns the ranges of open SKUs as:2 - 2 4 - 4 9 - 11 13 - 17 20 - 25 Rob Marquardt Designer/Resident Wirehead Toast Design800 Washington Avenue North Minneapolis MN 55401 612.330.9863 v 612.321.9424 f www.toastdesign.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://search.smithmicro.com/ Rob Marquardt

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:

Using Applescript to process WebCatalog functions (1998) Text data with spaces in them... (1997) Another Excel Problem (2003) WebDelivery downloads alias, not original ? (1997) Calculating Shipping charges for multiple items andqtys > 1 (1997) type 2 errors with ssl server (1997) Interfacing WebMerchant to www.fedex.com (1997) RE: [WebDNA] LowRam (2012) PSC recommends what date format yr 2000??? (1997) PCS Emailer's role ? (1997) [date] +1 (1999) Searching for Email Address (2004) installing webcatalog problem. HELP! (1998) multiple product databases (1997) Re[2]: Balancing randomness (2000) [WriteFile] problems (1997) Problems with [Search] param - Mac Plugin b15 (1997) bug in listwords? (1998) More than one db with the same namn (was: WC2f3) (1997) AOL and referrers on target=_blank (2000)