Re: [WebDNA] Combining searches

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112600
interpreted = N
texte = 182------=_Part_4326864_144606315.1457238987539Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: quoted-printableThe docs reference "ww" in "Searching>Word Breaks"I use the ww to search within the field where I separate the sections with =a "+" sign.Been doing that all along and it work fine searching for the sec=tions one by one.=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3Dwhole=C2=A0w=ord match (can be modified with=C2=A0wbrk=C2=A0to define word-break charact=ers)Descriptionword=3Dww=C2=A0looks for "graphic" and will=C2=A0not=C2=A0find i=t inside phrases such as: "I like typographic conventions". It=C2=A0will=C2==A0be found inside "This is a=C2=A0graphic."=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3DTrying just "wo" doesn't work at allI get every listing back with this (144 total ) .....[search db=3D^/rs2k/pr=oducts.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dwo&SECTIONSdata==3D12,31]Adding "rq" to Sectionsdata returns 0 items[search db=3D^/rs2k/products.db&=eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dwo&SECTIONSdatarq=3D12,31]:(=20 On Saturday, March 5, 2016 10:02 PM, Stuart Tremain wrote:=20 RichI think that you may have success with:=C2=A0SECTIONSword=3Dwo, I can=E2=80==99t see any reference in the docs to ww.Separate the words and "or" them together (at least one must match - defaul=t option for text). Search for 3 words using wo will match if any one of th=em matches.Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 6 Mar 2016, at 09:11, Rich Kwas wrote:Am I dong this right?Seems so based on the docs....I have items that appear multiple sections.Their section location in the db is stored as:+33+34+35+12+17+19+18+20+21+8=3+84+I want to find all items that appear in either section 12 or 19This is my code....[search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSK=Usort=3D1&SECTIONSword=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12,19]Section 12 has 87 itemsSection 19 has 7 itemsIf I use "&SECTIONSdatarq=3D12" I get back 87 which is correctIf I use "&SE=CTIONSdatarq=3D19" I get back 7 which is correctIf I use "&SECTIONSdatarq=3D12,19" I get back 141 which is the total of all= items,and should be just 94.I've tried it with "rq" and without "rq, same result.I'm using vers 6.2 on Windows Server 2008---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us---------------------------------------------------------This message is se=nt to you because you are subscribed tothe mailing list .To unsubscribe, E-=mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: =support@webdna.us ------=_Part_4326864_144606315.1457238987539Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable

The docs reference "ww" in "Sear=ching>Word Breaks"

I use the ww to sear=ch within the field where I separate the sections with a "+" sign.

Been doing that all along and it work fine =searching for the sections one by one.

=3D==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D

whole&nb=sp;word match (can be modified with wbrk to define word-break characters)

Descriptionword=3Dww looks for "graphic" and will not find it inside phrases such as: "I like typographic conventions". It&=nbsp;will be found inside "This is a graphic."

==3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D==3D=3D=3D=3D=3D

Trying just "wo" doesn't work a=t all

I get every listing back with this (1=44 total ) .....

[search db=3D^/rs2k/products.db&=;eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dwo&SECTIONSda=ta=3D12,31]

Adding "rq" to Sectionsdata returns 0 items

[search= db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECT=IONSword=3Dwo&SECTIONSdatarq=3D12,31]

:(

On Saturday, March 5, 2016 10:02 PM, Stuart Tr=emain <webdna@idfk.com.au> wrote:

Rich

<=/span>

I think that you may have success with: SECTIONSword=3Dwo, I can=E2=80=99t see any reference in the docs to ww.

Separate the words and "or" them together (at least one must match - defau=lt option for text). Search for 3 words using wo will match if any one of t=hem matches.

<=/span>

=



Kind regards

Stua=rt Tremain

IDFK Web Developments

AUSTRALIA

webdn=a@idfk.com.au

=

<=br clear=3D"none" class=3D"yiv4645892534Apple-interchange-newline">



On 6 Mar 2016, at 09:11, Ri=ch Kwas <richkwasniewski@yahoo.com> wrote:

Am I dong this right?

Seems so based on the docs....<=/div>

I have it=ems that appear multiple sections.

Their section location in the db is s=tored as:

+33+34+35+12+17+19+18+20+21+83+84+

I want to find all items that appe=ar in either section 12 or 19

This is my code....

[search db=3D^/rs2k=/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dw=w&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12,19]

Section 12 has 87 items

Section 19 has 7 items

If I use "&SECTIONSdatarq==3D12" I get back 87 which is correct

If I use "&=;SECTIONSdatarq=3D19" I get back 7 which is correct

If I use "&SECTIONSdatarq=3D12,19" I= get back 141 which is the total of all items,and should be just 94.

I've tried it with "rq=" and without "rq, same result.

I'm using vers 6.2 on Windows Server 2008

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.=webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us

=