Finding unused SKU's in a database

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 44685
interpreted = N
texte = 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-numberingissue has been resolved, however, I want to be able to find and use SKU'sthat fall in the range of all used SKU's that aren't being used.Example:Lowest SKU: 1Highest SKU: 533789456There's SKU's in between low and high that have been used. How would I listthe 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 ofthe loop matched the index of the above search, display the index, but ithangs 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/ Associated Messages, from the most recent to the oldest:

Re: Finding unused SKU's in a database (Gary Krockover 2002) Re: Finding unused SKU's in a database (Rob Marquardt 2002) Re: Finding unused SKU's in a database (Gyuri 2002) Re: Finding unused SKU's in a database (Gary Krockover 2002) Finding unused SKU's in a database (Gary Krockover 2002)

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-numberingissue has been resolved, however, I want to be able to find and use SKU'sthat fall in the range of all used SKU's that aren't being used.Example:Lowest SKU: 1Highest SKU: 533789456There's SKU's in between low and high that have been used. How would I listthe 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 ofthe loop matched the index of the above search, display the index, but ithangs 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/ 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:

WebCat2b12 - nesting [tags] (1997) Time Display from Database (1997) WebMerchant/MacAuthorize (1998) bug ? causes NT event log to fill (1997) [OT] Am I an Idiot? (2004) MySQL 4.1 (2004) Suse linux 9.0 AMD64 (2004) Order not created error (never mind) (1997) A little help on e-mail (HELP!!! :-) ) (1998) bug in [SendMail] (1997) no global [username] or [password] displayed ... (1997) shipCost not working v2.1b4 (1997) Aaron kant add (or whatever it was) (2000) ThreadMem ignored? (1998) Search for 20 finds 2000, 200 Why? (1997) Hello??? (1997) f2 download problems (1997) Advanced WebCat Guidelines - do they exist beyond docs (1999) Latin Characters (1998) Using [random] (1999)