Re: [WebDNA] group searching not working as expected.
This WebDNA talk-list message is from 2010
It keeps the original formatting.
numero = 106061
interpreted = N
texte = Coming in a =A0little late to this, but Ken's adding rq is=20all that's needed. Without rq, unless there is only one=20search parameter, it will find anything that fits=20something. So you'd want to add that to all 3 parts of the=20search. Allreqd=3Dt is not the same as adding rq to your=20search parameters. It means that each part of the search=20has to find something.=A0On Tue, 28 Dec 2010 22:54:14 -0500 Govinda
wrote:> Hi Ken>=20> Thanks for that!> It does work... even without the=20>"&allreqd=3DT&allblnk=3DT". (see *note below.)>=20> I need to check to be sure that none of my 'words' that=20>I might search for in the field (corresponding to the=20>[feeled1_Fruit] field in my example) might have a=20>word-delimiting char in their values.. (like a space=20>char). If not, then I think what you suggested will be=20>OK. I wanted to do it the other way so that regardless=20>of what characters might be in the value, it would not=20>break. I guess if I find any word-break chars in real=20>values.. then I'll get creative with "wbrk" & "fbrk".>=20> With regard to the grouped-field technique, I assume=20>that the moral of the story is that grouping fields only=20>works when there are no other field comparisons going=20>on, other than the grouped field(s).>=20> *Side note:> Interesting that when I add 'allreqd=3DT' to my original=20>search, like so:> [search db=20> =3D=20> my=20> .db &group1field =3D=20> feeled1_Fruit &group2field =3D=20> feeled1_Fruit &eqgroup1data=20>=3D1apple&eqgroup2data=3D3cherry&wsfeeled3_HowUseddatarq=3D[URL]baked=20> dessert[/URL]&allreqd=3DT&max=3D500]> ...it does not seem to have any effect at all.>=20> Thanks again!>=20> ------------> Govinda>=20>=20> On Dec 28, 2010, at 10:24 PM, Kenneth Grome wrote:>=20>> Have you tried this:>> &eqfeeled3_HowUseddatarq=3D[url]baked dessert[/url]>> &wofeeled1_Fruitdatarq=3D[url]1apple 3cherry 4mango[/url]>> &allreqd=3DT&allblnk=3DT&max=3D500>> Sincerely,>> Kenneth Grome>=20>=20>=20>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed=20>to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us=A0
Associated Messages, from the most recent to the oldest:
Coming in a =A0little late to this, but Ken's adding rq is=20all that's needed. Without rq, unless there is only one=20search parameter, it will find anything that fits=20something. So you'd want to add that to all 3 parts of the=20search. Allreqd=3Dt is not the same as adding rq to your=20search parameters. It means that each part of the search=20has to find something.=A0On Tue, 28 Dec 2010 22:54:14 -0500 Govinda wrote:> Hi Ken>=20> Thanks for that!> It does work... even without the=20>"&allreqd=3DT&allblnk=3DT". (see *note below.)>=20> I need to check to be sure that none of my 'words' that=20>I might search for in the field (corresponding to the=20>[feeled1_Fruit] field in my example) might have a=20>word-delimiting char in their values.. (like a space=20>char). If not, then I think what you suggested will be=20>OK. I wanted to do it the other way so that regardless=20>of what characters might be in the value, it would not=20>break. I guess if I find any word-break chars in real=20>values.. then I'll get creative with "wbrk" & "fbrk".>=20> With regard to the grouped-field technique, I assume=20>that the moral of the story is that grouping fields only=20>works when there are no other field comparisons going=20>on, other than the grouped field(s).>=20> *Side note:> Interesting that when I add 'allreqd=3DT' to my original=20>search, like so:> [search db=20> =3D=20> my=20> .db &group1field =3D=20> feeled1_Fruit &group2field =3D=20> feeled1_Fruit &eqgroup1data=20>=3D1apple&eqgroup2data=3D3cherry&wsfeeled3_HowUseddatarq=3D[url]baked=20> dessert[/URL]&allreqd=3DT&max=3D500]> ...it does not seem to have any effect at all.>=20> Thanks again!>=20> ------------> Govinda>=20>=20> On Dec 28, 2010, at 10:24 PM, Kenneth Grome wrote:>=20>> Have you tried this:>> &eqfeeled3_HowUseddatarq=3D[url]baked dessert[/url]>> &wofeeled1_Fruitdatarq=3D[url]1apple 3cherry 4mango[/url]>> &allreqd=3DT&allblnk=3DT&max=3D500>> Sincerely,>> Kenneth Grome>=20>=20>=20>=20>=20>=20> ---------------------------------------------------------> This message is sent to you because you are subscribed=20>to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> Bug Reporting: support@webdna.us=A0
"Terry Wilson"
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:
Fw: Webcat followup question (1999)
Which GUI HTML editors work with WC ? (1997)
Cookies (1999)
A better WebCat whois (was [OT] Domain Name Scam) (2000)
WebCat2b15MacPlugin - [protect] (1997)
PIXO (1997)
Changes to the List (1997)
[format xs] freeze (1997)
Running 2 two WebCatalog.acgi's (1996)
Weird Math and SV (1997)
[CART] inside a [LOOP] (1997)
Robots fill event log (1997)
Email Problems (2000)
Append command (1999)
$append (1998)
WebCatalog 2.0 b 15 mac (1997)
Accented chars and emailer (1998)
WebCat2b15MacPlugIn - [authenticate] not [protect] (1997)
(1997)
elmer fudd (2004)