Re: index code
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 63312
interpreted = N
texte = Good points! thank you Brian!chrisOn Oct 28, 2005, at 20:51, Brian Fries wrote:> Are you wanting these index values assigned randomly or > sequentially? Random is easier to generate (just pick two random > characters from the list of valid characters), but will potentially > take multiple attempts to find a unique value, especially when many > of the values have already been used. Sequential assignment makes > it easier to find a unique value - just find the highest current > value then generate the next value sequentially - but the > generation of the next value is trickier (see [listchars] and > [findstring] if you're using WebDNA version 6 - they will be > helpful here).>> Another significant consideration is that by default WebDNA's > searches are not case sensitive, so values of "aa", "Aa", "aA" and > "AA" are all seen as the same value. You will need to make sure to > specify that the index field is case sensitive (fieldnamecase=T) in > every search.>> - Brian>>> On Oct 28, 2005, at 3:49 PM, Christophe Billiottet wrote:>>>> Good evening to you all! we must index a database using no less >> and no more than two letters/numbers. To do this, each letter/ >> number must be in [a-z][A-Z][0-9] range. For instance, a record >> will be indexed 'c9' while another one will be 'Ht' or 'zs'.>>>> This gives 3844 possibilities (26+26+10)*(26+26+10)>>>> Does anyone has an idea to automatically create such an index? >> each time a record is added, a new unique two letters code index >> would be added.>>>> chris>>>>>> Brian Fries> BrainScan Software>>>>> -------------------------------------------------------------> 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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Good points! thank you Brian!chrisOn Oct 28, 2005, at 20:51, Brian Fries wrote:> Are you wanting these index values assigned randomly or > sequentially? Random is easier to generate (just pick two random > characters from the list of valid characters), but will potentially > take multiple attempts to find a unique value, especially when many > of the values have already been used. Sequential assignment makes > it easier to find a unique value - just find the highest current > value then generate the next value sequentially - but the > generation of the next value is trickier (see [listchars] and > [findstring] if you're using WebDNA version 6 - they will be > helpful here).>> Another significant consideration is that by default WebDNA's > searches are not case sensitive, so values of "aa", "Aa", "aA" and > "AA" are all seen as the same value. You will need to make sure to > specify that the index field is case sensitive (fieldnamecase=T) in > every search.>> - Brian>>> On Oct 28, 2005, at 3:49 PM, Christophe Billiottet wrote:>>>> Good evening to you all! we must index a database using no less >> and no more than two letters/numbers. To do this, each letter/ >> number must be in [a-z][A-Z][0-9] range. For instance, a record >> will be indexed 'c9' while another one will be 'Ht' or 'zs'.>>>> This gives 3844 possibilities (26+26+10)*(26+26+10)>>>> Does anyone has an idea to automatically create such an index? >> each time a record is added, a new unique two letters code index >> would be added.>>>> chris>>>>>> Brian Fries> BrainScan Software>>>>> -------------------------------------------------------------> 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 digest@talk.smithmicro.com>> Web Archive of this list is at: http://webdna.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://webdna.smithmicro.com/
Christophe Billiottet
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:
Re:Has this happened to you? (was:Emailer Chokes on bad address) (1997)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
Ok here is a question? (1997)
can we get string variables? (1998)
MacAuthorize hub, no modal password dialog? (1997)
Listfiles not listing mounted volume (2002)
RE: E-mailer error codes (1997)
New WebDNA Forum Solution (in development) (2003)
Re2: frames & carts (1997)
Trouble with [fileinfo] - update (2004)
Extended [ConvertChars] (1997)
Shipping by order total (2003)
Help! WebCat2 bug (1997)
Display [price] in banner ad (1998)
No messages for a week? (2000)
SKU generator? (1998)
more on quicktime test stuff (1997)
Problem (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
[Sum] function? (1997)