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:
this works sometimes and sometimes not (1997)
users.db (1999)
Just made store and move file from webcatalog......... (2000)
webdna on Leopard (2008)
Encrypted links ... (2000)
FlushDatabase Suggestion (1998)
WebCat for Unix?? (1997)
Way [OT] - OS 10.2 Server (2002)
A multi-processor savvy WebCatalog? (1997)
Cart Question (1998)
MacActivity and PCS (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Calculating multiple shipping... (1997)
Error Log.db --however (1997)
[WebDNA] WebDNA 7 fastcgi fails to start (2011)
Mozilla/4. and Browser Info.txt (1997)
Non Standard Product Display Layout (2000)
Frames and WebCat (1997)
Calendar (1997)
frames & carts (1997)