Re: searching for items that begin with a number

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58325
interpreted = N
texte = Yes, range is inclusive. A range with a max value of "9" will not=20 include the value "9A", because "9A" sorts after "9" alphabetically. This is why my example uses "9~~~~~~~~"... the tilde is the last=20 displayable standard ASCII character. Of course this will still result=20= in range issues if extended characters are used (such as accented=20 vowels - =E1 has a higher value, but the values of extended character=20 sets vary based on the encoding system). - brian On Jun 10, 2004, at 4:30 PM, Gary Krockover wrote: > When I was testing it, I naturally went &rnNAMESdatarq=3D0 9, but = found=20 > that it wouldn't find records that began with '9' for some reason,=20 > thus I went with 'a'. This is on WebDNA 6.0 on Win2k. Can someone=20 > else verify that? I though range was inclusive, but it was exclusive=20= > just for the high end value for some reason.... > > GK > > On Thu, 10 Jun 2004 15:39:31 -0700 > Brian Fries wrote: > >> If you just need those with a digit for the first character, I'd=20 >> suggest using "&rnNAMESdatarq=3D0 9~~~~~". >> >> - brian >> ------------------------------------------------------------- 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: searching for items that begin with a number ( "Gary Krockover" 2004)
  2. Re: searching for items that begin with a number ( Brian Fries 2004)
  3. Re: searching for items that begin with a number ( "Gary Krockover" 2004)
  4. Re: searching for items that begin with a number ( 2004)
  5. Re: searching for items that begin with a number ( Brian Fries 2004)
  6. Re: searching for items that begin with a number ( 2004)
  7. Re: searching for items that begin with a number ( Gary Krockover 2004)
  8. Re: searching for items that begin with a number ( 2004)
  9. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  10. Re: searching for items that begin with a number ( Gary Krockover 2004)
  11. Re: searching for items that begin with a number ( Gary Krockover 2004)
  12. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  13. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  14. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  15. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  16. Re: searching for items that begin with a number ( Gary Krockover 2004)
  17. Re: searching for items that begin with a number ( Gary Krockover 2004)
  18. Re: searching for items that begin with a number ( Dave Hurley 2004)
  19. Re: searching for items that begin with a number ( 2004)
  20. Re: searching for items that begin with a number ( 2004)
  21. Re: searching for items that begin with a number ( Dave Hurley 2004)
  22. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  23. Re: searching for items that begin with a number ( Donovan Brooke 2004)
  24. Re: searching for items that begin with a number ( "Dan Strong" 2004)
  25. searching for items that begin with a number ( 2004)
Yes, range is inclusive. A range with a max value of "9" will not=20 include the value "9A", because "9A" sorts after "9" alphabetically. This is why my example uses "9~~~~~~~~"... the tilde is the last=20 displayable standard ASCII character. Of course this will still result=20= in range issues if extended characters are used (such as accented=20 vowels - =E1 has a higher value, but the values of extended character=20 sets vary based on the encoding system). - brian On Jun 10, 2004, at 4:30 PM, Gary Krockover wrote: > When I was testing it, I naturally went &rnNAMESdatarq=3D0 9, but = found=20 > that it wouldn't find records that began with '9' for some reason,=20 > thus I went with 'a'. This is on WebDNA 6.0 on Win2k. Can someone=20 > else verify that? I though range was inclusive, but it was exclusive=20= > just for the high end value for some reason.... > > GK > > On Thu, 10 Jun 2004 15:39:31 -0700 > Brian Fries wrote: > >> If you just need those with a digit for the first character, I'd=20 >> suggest using "&rnNAMESdatarq=3D0 9~~~~~". >> >> - brian >> ------------------------------------------------------------- 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!

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: Nesting [ListFiles] (1998) Repeating Fields (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) RE: Formulas.db + Users.db (1997) help testing quicktime delivery (1997) Sorting by date (1997) AOL and webcat (1998) Stinkin' [Referrer] (1998) [WebDNA] WebDNA programmers for hire? (2010) Forbidden CGI Error (1997) Need relative path explanation (1997) Mac: LModelDirector bug fix (1997) webdelivery.html and webna (1997) Root Folder problems cont. (1998) Help formatting search results w/ table (1997) [WebDNA] Lookup serial number of purchase? (2011) Using [purchase] (1998) re:check boxes (1997) Plugin or CGI or both (1997) using showpage and showcart commands (1996)