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.txtSKU135How would I search and display that a SKU of 2 and 4 are available in theabove example?Thanks,GK| Sounds simple, I'm brainfried though:|| I have a database with thousands of SKU's. Generally, the SKU skips by5'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 Ilist| 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:

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)

I think I worded this funny. Here's a dummy approach:db=catalog.txtSKU135How would I search and display that a SKU of 2 and 4 are available in theabove example?Thanks,GK| Sounds simple, I'm brainfried though:|| I have a database with thousands of SKU's. Generally, the SKU skips by5'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 Ilist| 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:

MacAuthorize and WebMerchant (1997) form data submission gets truncated (1997) Adding extra coding on the fly? (2005) WebCat2: multiple currency support (1997) Help! WebCat2 bug (1997) Add more fields to an existent data base (1997) WebCatalog Serial Number (1998) Question about links (1999) New Command prefs ... (1997) Trigger time setting (2002) New command suggestion (1997) Problems setting MIME Headers (1998) RE: [REPLACE] inside [FOUNDITEMS] (1998) TCPsend with POST? (1999) RAM variables (1997) Multiple Merchant Accounts? (1997) Emailer error 571 (1998) last word listed (2000) Where is f2? (1997) Re:Emailer and encryption (1997)