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:

    
  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)
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:

WebCatalog Started!! Now What?? (2000) [shipCost] math formula? (1997) TCPconnect using SSL. If not WebCat, How? (1999) Attn: Bug in GeneralStore example b15 (1997) LookUp Tag (1997) Search (1997) Preloading code? (2002) [WebDNA] read database from other domain (2015) searching twice on same field (1998) New WebDNA Solutions ... (1997) WebCat b13 CGI -shownext- (1997) WebDelivery downloads alias, not original ? (1997) listdatabases,flushdatabases browser problem not webcat (2000) Emailer error 550? (1999) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) WebCat chatroom (1997) Add to a field (1998) Sorting a [listdatabases] (2003) Forms (1997) WebCommerce: Folder organization ? (1997)