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:

How can I Add several Items into the cart at once? (1997) Nested tags count question (1997) HTML (1999) complete escaped ascii chart - importing and exporting filesquestion (1998) Line items in table cells (1997) Nested searches (1998) using cookies to prevent access (2000) Unexpected error (1997) Smart caching problems with 2.1b3? (1997) Mass Mail (2000) [convertchars] problem... (2000) How can I Add several Items into the cart at once? (1997) Document Contains No Data! (1997) WebCat b13 CGI -shownext- (1997) IE problems persist (2004) RE: Problems with dbcatalog.exe (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Protecting Realms (1998) webcat- multiple selection in input field (1997) PSC recommends what date format yr 2000??? (1997)