Re: index code

This WebDNA talk-list message is from

2005

It keeps the original formatting. numero = 63311
interpreted = N
texte = 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.- BrianOn 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 FriesBrainScan 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

Re: index code ( Chris 2005)
Re: index code ( Brian Fries 2005)
index code ( Chris 2005)

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.- BrianOn 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 FriesBrainScan 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Brian Fries

DOWNLOAD WEBDNA NOW!

Re: index code

2005

Top Articles:

Related Readings: