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:

[WriteFile] problems (1997) transferring values (1998) [WebDNA] return missing db number (2010) Bug or syntax error on my part? (1997) Summing fields (1997) Date and Time Math (1997) WebCatalog2 Feature Feedback (1996) Denying access by IP address (2000) [WebDNA] OT - Selling Domain Names? (2009) [Announce]: Web server security and password protection (1997) upgrading (1997) WCS Newbie question (1997) Some Questions (1997) Undocumented changes create problems in webcat 4 ... (2000) Subtotal Not Calculated on Invoice.html (1998) WebCat website for developers and hosters (2001) form validator issue (2005) passing large amount of text in post form (2005) Proper file locations (1997) Need Sample Template - just purchased (1997)