Re: Finding unused SKU's in a database
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 44687
interpreted = N
texte = I think I worded this funny. Here's a dummy approach:db=catalog.txt SKU 1 3 5How would I search and display that a SKU of 2 and 4 are available in the above example?Thanks, GK | Sounds simple, I'm brainfried though: | | I have a database with thousands of SKU's. Generally, the SKU skips by 5's, | but not always. There's big gaps in the numbering. The auto-numbering | issue has been resolved, however, I want to be able to find and use SKU's | that fall in the range of all used SKU's that aren't being used. | | Example: | Lowest SKU: 1 | Highest SKU: 533789456 | | There's SKU's in between low and high that have been used. How would I list | the ones that have not? It's easy to find the total number of unused: | | [search db=catalog.txt&eqskudatarq=[blank]] | This many free SKU's: [numfound] |
| [/search] | | I've tried a loop that would count from 1 to max and then if the index of | the loop matched the index of the above search, display the index, but it | hangs the server. | | Any ideas? | | GK | | | ------------------------------------------------------------- | 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:
I think I worded this funny. Here's a dummy approach:db=catalog.txt SKU 1 3 5How would I search and display that a SKU of 2 and 4 are available in the above example?Thanks, GK | Sounds simple, I'm brainfried though: | | I have a database with thousands of SKU's. Generally, the SKU skips by 5's, | but not always. There's big gaps in the numbering. The auto-numbering | issue has been resolved, however, I want to be able to find and use SKU's | that fall in the range of all used SKU's that aren't being used. | | Example: | Lowest SKU: 1 | Highest SKU: 533789456 | | There's SKU's in between low and high that have been used. How would I list | the ones that have not? It's easy to find the total number of unused: | | [search db=catalog.txt&eqskudatarq=[blank]] | This many free SKU's: [numfound] |
| [/search] | | I've tried a loop that would count from 1 to max and then if the index of | the loop matched the index of the above search, display the index, but it | hangs the server. | | Any ideas? | | GK | | | ------------------------------------------------------------- | 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:
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
[cart] tag (2000)
emailer error type 103 (1997)
[WebDNA] also, is it right that the archives only go up to June (2008)
ShowNext (1997)
WebCat2.0 acgi vs plugin (1997)
How do you hide [math]stuff[/math] (1997)
message board (2001)
Updating fields from different platforms (1998)
WebDNA and SQL (2003)
[WebDNA] [ipaddress] - [RealIP] - Not working properly (2016)
New commands in Final candidate (1997)
dates and hex formatting (1997)
Draft Manual, Tutorial, and more (1997)
FRAME SRC references (2000)
date formatting for CC card expiration date check (1998)
Too Much Rootbeer Free Offer (1997)
[Fileinfo] Context (2000)
Multiple Pulldowns (1997)
Intermitent problem using [referrer] (1997)