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=20include the value "9A", because "9A" sorts after "9" alphabetically.This is why my example uses "9~~~~~~~~"... the tilde is the last=20displayable standard ASCII character. Of course this will still result=20=in range issues if extended characters are used (such as accented=20vowels - =E1 has a higher value, but the values of extended character=20sets vary based on the encoding system).- brianOn 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:
Yes, range is inclusive. A range with a max value of "9" will not=20include the value "9A", because "9A" sorts after "9" alphabetically.This is why my example uses "9~~~~~~~~"... the tilde is the last=20displayable standard ASCII character. Of course this will still result=20=in range issues if extended characters are used (such as accented=20vowels - =E1 has a higher value, but the values of extended character=20sets vary based on the encoding system).- brianOn 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)