Re: [WebDNA] Combining searches

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112603
interpreted = N
texte = 185------=_Part_4376031_461949651.1457267702001Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: quoted-printableAdding the "+" in the query seems to work, but it appears to summarize tota=l results, meaning if one item is in 3 sections, it gets totaled up as appe=aring "1x" not =C2=A0"3x"..... but that seems to make sense. =C2=A0I will c=ontinue with that routeThe docs on "Searching - Combining" separated the query items with a comma.=...Grouping doesn't sound like it'll work because I'm searching in just one fi=eld.=20 On Saturday, March 5, 2016 10:43 PM, Stuart Tremain wrote:=20 What about using + in the query ?[search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSw=ord=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12+19]Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 6 Mar 2016, at 15:36, Rich Kwas wrote:The 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 ---------------------------------------------------------This message is= sent to you because you are subscribed tothe mailing list .To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reportin=g: 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_4376031_461949651.1457267702001Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable

Adding the "+" in the query seem=s to work, but it appears to summarize total results, meaning if one item i=s in 3 sections, it gets totaled up as appearing "1x" not "3x"..... b=ut that seems to make sense. I will continue with that route

The docs on "Searching - Combining" separated the query items =with a comma...

Grouping doesn't sound like it'll work because I'm searching in just one= field.

<=/div>

On Saturday, March 5, 2016 10:43 PM, Stuart Tremain <web=dna@idfk.com.au> wrote:

What about using + in the query ?<=div class=3D"yiv7635206698">

[search db=3D^/rs2k/products.db&eqVisibledatarq==3DT&asSKUsort=3D1&SECTIONSword=3Dww&SECTIONSwbrk=3D+&SECTI=ONSdatarq=3D12+19]

Kind regards

Stua=rt Tremain

IDFK Web Developments

AUSTRALIA

webdn=a@idfk.com.au

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

On 6 Mar 2016, at 15:36, Ri=ch Kwas <richkwasniewski@yahoo.com> wrote:
The docs reference "ww" in "Searching>Word Breaks"

I use the ww to sea=rch within the field where I separate the sections with a "+" sign.<=/div>
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 word match (can be modified with wbrk to define word-break cha=racters)

Descriptionword=3Dww= looks for "graphic" and will not find it inside phrases such as: "I like =typographic conventions". It 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" do=esn't work at all

I get every listing back with this (144 total ) .....
<=div class=3D"yiv7635206698" dir=3D"ltr" id=3D"yiv7635206698yui_3_16_0_1_145=7215336165_19664">[search db=3D=^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSwo=rd=3Dwo&SECTIONSdata=3D12,31]

Adding "rq" to Sectionsdata returns 0 items
[search db==3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTION=Sword=3Dwo&SECTIONSdatarq=3D12,31]

:(

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

Rich

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

=
Separate the words and "or" them together (at least one must match - de=fault option for text). Search for 3 words using wo will match if any one o=f them matches.

Kind regards

Stua=rt Tremain
IDFK Web Developments
AUSTRALIA
webdn=a@idfk.com.au

=

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

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

Am I dong this right?
Seems s=o based on the docs....

I have items that appear multiple sections.

Their sectio=n location in the db is stored as:
+33+34+35+12+17+1=9+18+20+21+83+84+

I want to f=ind all items that appear in either section 12 or 19

This is my code....
[search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort==3D1&SECTIONSword=3Dww&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 correc=t

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

<=/div>---------------------------------------------------------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

---------------------------------------------------------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: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us------=_Part_4376031_461949651.1457267702001--. Associated Messages, from the most recent to the oldest:

Re: [WebDNA] Combining searches (Terry Wilson 2016)
Re: [WebDNA] Combining searches (Rich Kwas 2016)
Re: [WebDNA] Combining searches (Terry Wilson 2016)
Re: [WebDNA] Combining searches (Stuart Tremain 2016)
Re: [WebDNA] Combining searches (Rich Kwas 2016)
Re: [WebDNA] Combining searches (Stuart Tremain 2016)
[WebDNA] Combining searches (Rich Kwas 2016)
Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
Re: [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
[WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)

185------=_Part_4376031_461949651.1457267702001Content-Type: text/plain; charset=UTF-8Content-Transfer-Encoding: quoted-printableAdding the "+" in the query seems to work, but it appears to summarize tota=l results, meaning if one item is in 3 sections, it gets totaled up as appe=aring "1x" not =C2=A0"3x"..... but that seems to make sense. =C2=A0I will c=ontinue with that routeThe docs on "Searching - Combining" separated the query items with a comma.=...Grouping doesn't sound like it'll work because I'm searching in just one fi=eld.=20 On Saturday, March 5, 2016 10:43 PM, Stuart Tremain wrote:=20 What about using + in the query ?[search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSw=ord=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12+19]Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.auOn 6 Mar 2016, at 15:36, Rich Kwas wrote:The 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 ---------------------------------------------------------This message is= sent to you because you are subscribed tothe mailing list .To unsubscribe,= E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reportin=g: 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_4376031_461949651.1457267702001Content-Type: text/html; charset=UTF-8Content-Transfer-Encoding: quoted-printable