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:

Netscape v. IE (1997) "&" character in Flash animation (2004) The USArea® Network web site ... (1997) America Online Issues (1998) can WC render sites out? (1997) Not really WebCat (1997) NT 2.1b10 (1998) Webstar 1.3.1 PPC (1997) Trunk-gator (1997) Last freebie (1998) emailer (1997) Upcoming 2.1 Release and PCS Committment (1997) What if SSL server down? MAC (1997) [showif],[refferer],[include] in errormessages.db (2002) Signal Raised (1997) Locking up with WebCatalog... (1997) WebCat2 - [include] tags (1997) More on ShippingCost help needed (1998) OK, here goes... (1997) [WebDNA] TCPConnect Slowness (2013)