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! chris On 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:

    
  1. Re: index code ( Chris 2005)
  2. Re: index code ( Brian Fries 2005)
  3. index code ( Chris 2005)
Good points! thank you Brian! chris On 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:

WebCatalog can't find database (1997) URL'ed value not written to DB URL'ed (2003) Proper file locations (1997) Displaying photo attached to first record (1997) Multiple Newcarts (1996) [TaxableTotal] - not working with AOL and IE (1997) [WebDNA] WebDNA for Windows Newbie Questions (2008) Fun with dates (1997) Re2: Calculating multiple shipping... (1997) FW: WebDNA-Talk searchable? (1997) Search in 2 or more catalogs (1997) Explorer 3.0/ Access Denied! (1997) WebCat editing, SiteGuard WAS:SiteAssociative lookup style? (1997) username = 115 (1999) Help formatting search results w/ table (1997) Loop context to replace items (1998) WebDNA 4.5.1 Now Available (2003) Date/Time format problems (1997) RE: [WebDNA] smtp authentication (2008) WebCat2b12plugin - [search] is broken ... not! (1997)