Re: searching for items that begin with a number

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58323
interpreted = N
texte = > If you just need those with a digit for the first character, I'd > suggest using "&rnNAMESdatarq=0 9~~~~~". What is "~~~~~" after 9 for? Eduardo ----- Original Message ----- From: "Brian Fries" To: "WebDNA Talk" Sent: Thursday, June 10, 2004 3:39 PM Subject: Re: searching for items that begin with a number > The range method from "0" to "a" would also find records with NAMES > exactly equal to "a". > > And the "le" method will NOT find records with NAMES beginning with 9 > then a letter ("9BOB" > "9999999") > > And what of NAMES beginning with a punctuation character (e.g. "#BOB")? > Are they an issue for you? Some of them are less than "0" (space, !, > #), some are between "9" and "A" (:, ?, @) and others are greater than > "Z" (\, _, {). > > Here's the set of NAMES I've been playing with: > > Fred > #fred > 0 > 493 bob 88 > 9 > 9ZZZZZ > 9_bob > A > a > Bill 99 > cat > Dog > ZZbob > zzBOB > [george] > _dude > {mike} > > > I've tried group fields to search the NAMES field twice, but haven't > come up with a single search that finds records either less than "A" or > greater than "Z~~~~~~~~~~~". > > If you just need those with a digit for the first character, I'd > suggest using "&rnNAMESdatarq=0 9~~~~~". > > - brian > > On Jun 10, 2004, at 1:55 PM, wrote: > > > Thanks for all the help. > > Both search criterias work for me > > > > &rnNAMESdatarq=0 a > > &leNAMESdatarq=9999999&NAMEStype=text > > > > Eduardo > > > > ----- Original Message ----- > > From: "Gary Krockover" > > To: "WebDNA Talk" > > Sent: Thursday, June 10, 2004 1:44 PM > > Subject: Re: searching for items that begin with a number > > > > > >> Ok, added it and this still works for me: > >> > >> [search db=data.db&rnNAMESdatarq=0 a] > >> FOUND: [numfound]
> >> [founditems] > >> [names]
> >> [/founditems] > >> [/search] > >> > >> GK > >> > >> At 03:40 PM 6/10/2004, you wrote: > >>> Hello Gary > >>> > >>> Your data.db is missing an item that has more than > >>> 1 word w/ any words excluding first word beginning > >>> with a number. > >>> > >>> i.e > >>> bill 99 > >>> > >>> Eduardo > >> > >> > >> ------------------------------------------------------------- > >> 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/ > > > > > > ------------------------------------------------------------- > > 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/ > > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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)
> If you just need those with a digit for the first character, I'd > suggest using "&rnNAMESdatarq=0 9~~~~~". What is "~~~~~" after 9 for? Eduardo ----- Original Message ----- From: "Brian Fries" To: "WebDNA Talk" Sent: Thursday, June 10, 2004 3:39 PM Subject: Re: searching for items that begin with a number > The range method from "0" to "a" would also find records with NAMES > exactly equal to "a". > > And the "le" method will NOT find records with NAMES beginning with 9 > then a letter ("9BOB" > "9999999") > > And what of NAMES beginning with a punctuation character (e.g. "#BOB")? > Are they an issue for you? Some of them are less than "0" (space, !, > #), some are between "9" and "A" (:, ?, @) and others are greater than > "Z" (\, _, {). > > Here's the set of NAMES I've been playing with: > > Fred > #fred > 0 > 493 bob 88 > 9 > 9ZZZZZ > 9_bob > A > a > Bill 99 > cat > Dog > ZZbob > zzBOB > [george] > _dude > {mike} > > > I've tried group fields to search the NAMES field twice, but haven't > come up with a single search that finds records either less than "A" or > greater than "Z~~~~~~~~~~~". > > If you just need those with a digit for the first character, I'd > suggest using "&rnNAMESdatarq=0 9~~~~~". > > - brian > > On Jun 10, 2004, at 1:55 PM, wrote: > > > Thanks for all the help. > > Both search criterias work for me > > > > &rnNAMESdatarq=0 a > > &leNAMESdatarq=9999999&NAMEStype=text > > > > Eduardo > > > > ----- Original Message ----- > > From: "Gary Krockover" > > To: "WebDNA Talk" > > Sent: Thursday, June 10, 2004 1:44 PM > > Subject: Re: searching for items that begin with a number > > > > > >> Ok, added it and this still works for me: > >> > >> [search db=data.db&rnNAMESdatarq=0 a] > >> FOUND: [numfound]
> >> [founditems] > >> [names]
> >> [/founditems] > >> [/search] > >> > >> GK > >> > >> At 03:40 PM 6/10/2004, you wrote: > >>> Hello Gary > >>> > >>> Your data.db is missing an item that has more than > >>> 1 word w/ any words excluding first word beginning > >>> with a number. > >>> > >>> i.e > >>> bill 99 > >>> > >>> Eduardo > >> > >> > >> ------------------------------------------------------------- > >> 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/ > > > > > > ------------------------------------------------------------- > > 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/ > > > > > ------------------------------------------------------------- > 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/ ------------------------------------------------------------- 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/

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:

PSC recommends what date format yr 2000??? (1997) Tiger / WebDNA (2005) convert date and time (2005) absolute paths for databases? (1997) Sum of [founditems] ? (2004) webcat2b12 CGI -- Date comparisons (1997) FYI: virus alert (1996) Problems with Price field (1997) Banners (1997) Calendar (1997) Add more fields to an existent data base (1997) Max Record length restated as maybe bug (1997) mass mailing (1998) How To Install (2003) Createfolder / writefile problem (2004) NetForms for mail, sorry (1998) multi-paragraph fields (1997) user flush db (2002) setting cookies then redirecting? (1998) Frames and WebCat (1997)