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 haveto 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 inthe| > 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:
Excellent, pretty much working as needed.Thanks!And thanks Gyuri for your suggestion as well, but I was hoping to not haveto 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 inthe| > 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:
[thisurl] (2004)
Multiple security dbs (1997)
WebCatalog2 Feature Feedback (1996)
Accessing SQL server from OSX (2001)
WebCat2: Items xx to xx shown, etc. (1997)
expired beta (1997)
switching users (1998)
WebCat2_Mac RETURNs in .db (1997)
WebCat2: Items xx to xx shown, etc. (1997)
F3 crashing server (1997)
Accessing Server Environment Variables (2003)
fresh eyes needed. Append won't work. (2000)
Webcatalog error, Plug-in for Webstar (1996)
[WebDNA] reply vs. new (2009)
My server admin needs help ... (2004)
VCF Card (1998)
Single Link browsing (1997)
The USArea® Network web site ... (1997)
PhotoMill -> PhotoMaster (1997)
WebCommerce: Folder organization ? (1997)