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=20 all that's needed. Without rq, unless there is only one=20 search parameter, it will find anything that fits=20 something. So you'd want to add that to all 3 parts of the=20 search. Allreqd=3Dt is not the same as adding rq to your=20 search parameters. It means that each part of the search=20 has to find something.=A0 On 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=20 all that's needed. Without rq, unless there is only one=20 search parameter, it will find anything that fits=20 something. So you'd want to add that to all 3 parts of the=20 search. Allreqd=3Dt is not the same as adding rq to your=20 search parameters. It means that each part of the search=20 has to find something.=A0 On 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:
Summing fields (1997)
You are not allowed to change the price (2003)
Help! WebCat2 bug (1997)
Why isn't this working (1999)
[format] question (2000)
PSC recommends what date format yr 2000??? (1997)
Showif probably dumb question (1997)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
[group] ? (1997)
Migrating to NT (1997)
different ship dates and shopping carts -- how to? (1997)
WebCat2final1 crashes (1997)
b12 cannot limit records returned and more. (1997)
WebCatalog for Mac 2.0.1 Released (1997)
WebCatalog can't find database (1997)
PCS Frames (1997)
Images in Globals? (2003)
Automatic POST arg sending? (1998)
wo search help (1999)
autocommit problem (1998)