Re: searching for items that begin with a number
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58322
interpreted = N
texte = 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#fred0493 bob 8899ZZZZZ9_bobAaBill 99catDogZZbobzzBOB[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~~~~~".- brianOn 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/
Associated Messages, from the most recent to the oldest:
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#fred0493 bob 8899ZZZZZ9_bobAaBill 99catDogZZbobzzBOB[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~~~~~".- brianOn 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/
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:
RequiredFields template (1997)
View Source from cache (1997)
Re:Searchable Archives (1998)
GuestBook example (1997)
[WebDNA] reverse rank=off (2008)
[OT] gMail accounts (2004)
Looking up two prices in database? (1997)
Help! WebCat2 bug (1997)
Location of Browser Info.txt file (1997)
IE problems persist (2004)
Talk List Suggestions (1997)
get vs post - Back to Basics. (2001)
WebCat for Unix?? (1997)
encrypt/decrypt problems (2001)
[BULK] [WebDNA] Anyone using Ubuntu 17.04 yet? (2017)
[TEST] - Please Ignore (2000)
List Address Changed! (1998)
Newbie questions (1999)
[WebDNA] EMailer timezone bug? (2015)
[shownext] and sort (1998)