Re: Finding unused SKU's in a database

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 44706
interpreted = N
texte = Excellent, pretty much working as needed.Thanks!And thanks Gyuri for your suggestion as well, but I was hoping to not have to use a [loop] for the process.GK| 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 | 26 | | It returns the ranges of open SKUs as: | | 2 - 2 | 4 - 4 | 9 - 11 | 13 - 17 | 20 - 25 | | | Rob Marquardt | Designer/Resident Wirehead | Toast Design | | 800 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/ ------------------------------------------------------------- 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)
Excellent, pretty much working as needed.Thanks!And thanks Gyuri for your suggestion as well, but I was hoping to not have to use a [loop] for the process.GK| 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 | 26 | | It returns the ranges of open SKUs as: | | 2 - 2 | 4 - 4 | 9 - 11 | 13 - 17 | 20 - 25 | | | Rob Marquardt | Designer/Resident Wirehead | Toast Design | | 800 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/ ------------------------------------------------------------- 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/ Gary Krockover

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:

Re:What file? (1997) Speed questions (1998) Trying to find information. (2001) Problems adding stuff to the shopping cart. (1997) BIG PROBLEMS with Checkboxes!!! (1998) Search results templates (1996) formulas.db (1999) EmailCompleted Clean Up (2001) Lost and Recovered. (1998) Error Lob.db records error message not name (1997) Random Images (2000) ShipCost formula (for weight *and* quantities)? (1998) I forgot (1998) Giving out error pages (1997) WebCat2: multiple currency support (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) search problem (2002) Bug or syntax error on my part? (1997) RE: Help name our technology! (1997) $Append for Users outside the ADMIN group (1997)