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:

Forms Search Questions (1997) More DateMath problems (1997) NT version and O'reily's WebSite (1997) bug in Webcat OSX (1999) [append] vs. [appendfile] delta + question? (1997) TCPConnect & TCPSend (2003) Getting Emailer to send mail (1997) MacAuthorize order data fields WAS:How To question... (1997) Location of Browser Info.txt file (1997) WC Database Format (1997) How true is this? (1999) Feature: TCPconnect via SSL (1999) OT: NT mac sharing (1998) [SHOWIF AND/OR] (1997) $Replace with [founditems] (1997) sort problems....bug or brain fart? (1997) include bug????? (1997) format_to_days on NT (1997) GoodPath and MoveFile (edited and reposted) (2000) Need relative path explanation (1997)