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:
Multiple security dbs (1997)
New commands in Final candidate (1997)
[WebDNA] Spambots, message boards and such (2008)
f2 download problems (1997)
Reversed words (1997)
Cookies and WebCat?? (1999)
A little syntax help (1997)
Sendmail (2000)
WebCatalog for Postcards ? (1997)
shownext problems & formvariables (1998)
Multiple catalog databases and showcart (1997)
Fun with Dates - finally resolved but.... (1997)
Protecting webdelivery (1997)
anyone interested in doing an open-source WebCat based forum? (2002)
How to Display text in empty fields (1997)
Support suggestions - long (was politeness, et al) (2000)
How can I Add several Items into the cart at once? (1997)
Running 2 two WebCatalog.acgi's (1996)
Hiding HTML and page breaks (1997)
Looking up two prices in database? (1997)