Re: Finding unused SKU's in a database

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 44690
interpreted = N
texte = I would search for the max and min, then loop between these two. In the loop do lookups, - as lookups supposed to be very fast - for all the SKU-s. If the SKU not found, it goes into a free SKU-s database.HTH, GyuriGary Krockover wrote:>I think I worded this funny. Here's a dummy approach: > >db=catalog.txt >SKU >1 >3 >5 > >How 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/ > > > >-- Gyuri Ordody Objects Online, Inc.------------------------------------------------------------- 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 would search for the max and min, then loop between these two. In the loop do lookups, - as lookups supposed to be very fast - for all the SKU-s. If the SKU not found, it goes into a free SKU-s database.HTH, GyuriGary Krockover wrote:>I think I worded this funny. Here's a dummy approach: > >db=catalog.txt >SKU >1 >3 >5 > >How 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/ > > > >-- Gyuri Ordody Objects Online, Inc.------------------------------------------------------------- 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/ Gyuri

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:

[ShowNext] feature in 2.0 (1997) Big Databases (1997) OT: advice on Wintel server options (1998) WCS Newbie question (1997) [SHOWIF]s and empty arguments (1997) WebCatalog Mac 2.1b3 (1997) Navigator 4.01 (1997) writefile and emailer (2002) [UPPERCASE] (1997) numfound=0 for a search after going into the SSL (2003) Site Test Please (2005) [WebDNA] test post (2011) OFF-TOPIC: For Gary Krockover ... (2003) [WebDNA] =?UTF-8?B?UmU6IFtXZWJETkFdIFJlOiBbV2ViRE5BXSBSZTogW1dlYkROQV0gUmU6IFtXZWJETkFdIA==?= (2011) [WebDNA] securing passing info from php to webdna (2011) SSL and WebCatalog (1997) Moment of Thanks (1997) MacActivity and PCS (1997) FW: ANother SHOWIF problem (1997) carriage returns in data (1997)