Re: Grouping fields help
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 57726
interpreted = N
texte = Speaking from a logic standpoint, that is an "or". You want 11 *or* 100 and nothing else (mc can't be equal to 11 *and* 100 at the same time).Thus a required Word Or (wo) comparison would be your answer, with a Whole Word match so you that 11 doesn't match 110 (which contains 11). No grouping necessary, since you are only testing one field.womcdatarq=11+100&mcword=ww- brianOn May 10, 2004, at 9:14 AM, Gary Krockover wrote:> I want it to find 11 *and* 100. Removing the rq finds all records > (11, 100, 55, 22, etc...)>> GK>> At 11:07 AM 5/10/2004, you wrote:>> on 5/10/2004 10:47 am, Gary Krockover at gary@garykrockover.com so >> noted...>>>> > Thanks D, I figured it was the "searching the same field twice" >> scenario,>> > though I thought that's what grouping would bypass.>>>> It does. You want the search to find 11 *or* 100, so remove the "rq" >> from>> both comparisons.>>>> [search>> db=capture.db&eqgroup1data=11&group1field=mc&eqgroup2data=100&group2fi >> eld=mc>> &asindatesort=1&indatetype=date&asmcsort=2&mctype=num]-------------------------------------------------------------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:
Speaking from a logic standpoint, that is an "or". You want 11 *or* 100 and nothing else (mc can't be equal to 11 *and* 100 at the same time).Thus a required Word Or (wo) comparison would be your answer, with a Whole Word match so you that 11 doesn't match 110 (which contains 11). No grouping necessary, since you are only testing one field.womcdatarq=11+100&mcword=ww- brianOn May 10, 2004, at 9:14 AM, Gary Krockover wrote:> I want it to find 11 *and* 100. Removing the rq finds all records > (11, 100, 55, 22, etc...)>> GK>> At 11:07 AM 5/10/2004, you wrote:>> on 5/10/2004 10:47 am, Gary Krockover at gary@garykrockover.com so >> noted...>>>> > Thanks D, I figured it was the "searching the same field twice" >> scenario,>> > though I thought that's what grouping would bypass.>>>> It does. You want the search to find 11 *or* 100, so remove the "rq" >> from>> both comparisons.>>>> [search>> db=capture.db&eqgroup1data=11&group1field=mc&eqgroup2data=100&group2fi >> eld=mc>> &asindatesort=1&indatetype=date&asmcsort=2&mctype=num]-------------------------------------------------------------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:
typhoon ? (2003)
Inconsistent Code (2006)
[replaceChars] would be nice ... (1997)
RE: 2.01 upgrade problems (1997)
Webcatalog/NT dbserver crashing. (2000)
show all problem (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
2 things: CartSweep and Manual (2003)
Emailer (1997)
Possible Bug in 2.0b15.acgi (1997)
RE: Nesting [ListFiles] (1998)
Modifying order output (1997)
RE: How much ram??? (1997)
carriage returns in data (1997)
ReturnRaw context (1997)
Don't do this! (was: Crashing Type 3) (1999)
[WebDNA] WebDNA app (2013)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Ranking customers (2003)
Snake Bites (1997)