Re: How is it done?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17583
interpreted = N
texte = >>Does using the rn parameter in a search like this require that we also >>put FieldNameType=num into the search parameters? > >Yes, ranges actually do work for numbers and dates (and text), but you have >to tell it what type they are, just as you would for sorting. For a text >range, E is in between C and K. rn searching does *NOT* work properly when you tell WebCat to do a numeric range search by adding fieldNameType=num to the search parameters.The only way I can get rn searching to work is to leave the fieldNameType=num parameter out, then it works okay -- provided the number of digits in the field is exactly the same in every record ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: How is it done? (Kenneth Grome 1998)
  2. Re: How is it done? (PCS Technical Support 1998)
  3. Re: How is it done? (PCS Technical Support 1998)
  4. Re: How is it done? (Trevor Crist 1998)
  5. Re: How is it done? (Kenneth Grome 1998)
  6. Re: How is it done? (Kenneth Grome 1998)
  7. Re: How is it done? (PCS Technical Support 1998)
  8. Re: How is it done? (Kenneth Grome 1998)
  9. Re: How is it done? (PCS Technical Support 1998)
  10. How is it done? (Kenneth Grome 1998)
>>Does using the rn parameter in a search like this require that we also >>put FieldNameType=num into the search parameters? > >Yes, ranges actually do work for numbers and dates (and text), but you have >to tell it what type they are, just as you would for sorting. For a text >range, E is in between C and K. rn searching does *NOT* work properly when you tell WebCat to do a numeric range search by adding fieldNameType=num to the search parameters.The only way I can get rn searching to work is to leave the fieldNameType=num parameter out, then it works okay -- provided the number of digits in the field is exactly the same in every record ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Kenneth Grome

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:

[UPPERCASE] (1997) Question re: FlushDatabases (1997) Showif, Hideif reverse logic ? (1997) Associative lookup style? + bit more (1997) WebCatalog can't find database (1997) BGcolor (1997) [WebDNA] Encode cookies ONLY via "method=Base64" (2008) Sku numbers (1997) Mass Mail (2000) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) Lock out multiple users with same password? (1999) IE4.5 bug FYI (1999) Enhanced Master Counter? (1997) What Country (2004) Help! WebCat2 bug (1997) NT version (1997) Comments in db? (1997) webten vs. webstar (1998) To Err or Not Custom Error (1999) Width & Height (1998)