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