Re: [WebDNA] Combining searches

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112604
interpreted = N
texte = 186--Apple-Mail-0842CB80-49AD-442D-A452-4CEDACDBE07BContent-Type: text/plain;charset=utf-8Content-Transfer-Encoding: quoted-printableThe point of grouping is to search the same field in two different ways. Loo=k at the docs and give it a try. It's really the simplest way to get what yo=u want.Sent from my iPad> On Mar 6, 2016, at 4:35 AM, Rich Kwas wrote:>=20> Adding the "+" in the query seems to work, but it appears to summarize tot=al results, meaning if one item is in 3 sections, it gets totaled up as appe=aring "1x" not "3x"..... but that seems to make sense. I will continue wit=h that route>=20> The docs on "Searching - Combining" separated the query items with a comma=....>=20> Grouping doesn't sound like it'll work because I'm searching in just one f=ield.>=20>=20>=20>=20> On Saturday, March 5, 2016 10:43 PM, Stuart Tremain w=rote:>=20>=20> What about using + in the query ?>=20> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONS=word=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12+19]>=20>=20> Kind regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20>=20>> On 6 Mar 2016, at 15:36, Rich Kwas wrote:>>=20>> The docs reference "ww" in "Searching>Word Breaks">>=20>> I use the ww to search within the field where I separate the sections wit=h a "+" sign.>> Been doing that all along and it work fine searching for the sections one= by one.>>=20>> =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 characte=rs)>>=20>> Descriptionword=3Dww looks for "graphic" and will not find it inside phra=ses 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>>=20>> Trying just "wo" doesn't work at all>>=20>> I get every listing back with this (144 total ) .....>> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTION=Sword=3Dwo&SECTIONSdata=3D12,31]>>=20>> Adding "rq" to Sectionsdata returns 0 items>> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTION=Sword=3Dwo&SECTIONSdatarq=3D12,31]>>=20>> :(>>=20>>=20>>=20>>=20>> On Saturday, March 5, 2016 10:02 PM, Stuart Tremain w=rote:>>=20>>=20>> Rich>>=20>> I think that you may have success with: SECTIONSword=3Dwo, I can=E2=80=99=t see any reference in the docs to ww.>>=20>> Separate the words and "or" them together (at least one must match - defa=ult option for text). Search for 3 words using wo will match if any one of t=hem matches.>>=20>>=20>> Kind regards>>=20>> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au>>=20>>=20>>=20>>=20>>=20>>> On 6 Mar 2016, at 09:11, Rich Kwas wrote:>>>=20>>> Am I dong this right?>>> Seems so based on the docs....>>>=20>>> I have items that appear multiple sections.>>>=20>>> Their section location in the db is stored as:>>> +33+34+35+12+17+19+18+20+21+83+84+>>>=20>>> I want to find all items that appear in either section 12 or 19>>>=20>>> This is my code....>>> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIO=NSword=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12,19]>>>=20>>> Section 12 has 87 items>>> Section 19 has 7 items>>>=20>>> If I use "&SECTIONSdatarq=3D12" I get back 87 which is correct>>> If I use "&SECTIONSdatarq=3D19" I get back 7 which is correct>>>=20>>> If I use "&SECTIONSdatarq=3D12,19" I get back 141 which is the total of a=ll items,and should be just 94.>>>=20>>> I've tried it with "rq" and without "rq, same result.>>>=20>>>=20>>>=20>>> I'm using vers 6.2 on Windows Server 2008>>>=20>>>=20>>>=20>>>=20>>>=20>>> --------------------------------------------------------- This message i=s sent to you because you are subscribed to the mailing list . To unsubscrib=e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Report=ing: support@webdna.us>>=20>> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe=, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti=ng: support@webdna.us>>=20>>=20>> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe=, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti=ng: support@webdna.us>=20> --------------------------------------------------------- This message is s=ent to you because you are subscribed to the mailing list . To unsubscribe, E=-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us>=20>=20> --------------------------------------------------------- This message is s=ent to you because you are subscribed to the mailing list . To unsubscribe, E=-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us--Apple-Mail-0842CB80-49AD-442D-A452-4CEDACDBE07BContent-Type: text/html;charset=utf-8Content-Transfer-Encoding: quoted-printable

The point of grouping is to search the= same field in two different ways. Look at the docs and give it a try. It's r=eally the simplest way to get what you want.

Sent from my iPad

<=div>
On Mar 6, 2016, at 4:35 AM, Rich Kwas <richkwasniewski@yahoo.com> wrote:

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

<=div id=3D"yui_3_16_0_1_1457266621417_14683">

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

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

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

What about using += in the query ?

[search db=3D^/rs2k/products.db&eqVis=ibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dww&SECTIONSwbrk=3D+&=amp;SECTIONSdatarq=3D12+19]

Kind regards

Stuart Trem=ain

IDFK Web Developments

AUSTRALIA

webdna@idfk.com.au=

On 6 Mar 2016, at 15:36, Rich K=was <richkwasniewski@yahoo.com> wrote:

The docs reference "ww" in "Searching>Word Breaks"
=
I use the ww to search within the field w=here 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 word match (can be modified wi=th w=brk =to define word-break characters)

Descriptionword=3Dww looks for "graphic" and will not find it inside phrases such as: "I l=ike 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" doesn't work at all

I get every listing back with th=is (144 total ) .....
[search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&a=mp;asSKUsort=3D1&SECTIONSword=3Dwo&SECTIONSdata=3D12,31]

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

:(

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

Rich=

<=span class=3D"yiv7635206698" style=3D"background-color:rgb(255, 255, 255);">=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 t=ogether (at least one must match - default option for text). Search for 3 wo=rds using wo will match if any one of them matches.

Kind regards

Stuart Trem=ain
IDFK Web Developments
AUSTRALIA
webdna@idfk.com.au=

On 6 M=ar 2016, at 09:11, Rich Kwas <richkwasniewski@yahoo.com&g=t; wrote:

Am I dong this right?
Seems so based on the d=ocs....

I ha=ve items 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 appear in eith=er section 12 or 19

T=his is my code....
[search db=3D^/rs2k/products.db&=;eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dww&SECTIONSwbr=k=3D+&SECTIONSdatarq=3D12,19]
=

Section 12 has 87 items
Section 19 has 7 i=tems

=
If I use "&SECTIONSdatarq=3D12" I get back 87 which is c=orrect
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 i=tems,and should be just 94.
=

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

I'm using vers 6.2 on W=indows Server 2008

---------------------------------------------------------This message is sent to you because you are subscribed tothe mailing list .To unsubscribe, E-mail to:=20archives: http://mail.webd=na.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.webd=na.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=---------------------------------------------------------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--Apple-Mail-0842CB80-49AD-442D-A452-4CEDACDBE07B--. 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)

186--Apple-Mail-0842CB80-49AD-442D-A452-4CEDACDBE07BContent-Type: text/plain;charset=utf-8Content-Transfer-Encoding: quoted-printableThe point of grouping is to search the same field in two different ways. Loo=k at the docs and give it a try. It's really the simplest way to get what yo=u want.Sent from my iPad> On Mar 6, 2016, at 4:35 AM, Rich Kwas wrote:>=20> Adding the "+" in the query seems to work, but it appears to summarize tot=al results, meaning if one item is in 3 sections, it gets totaled up as appe=aring "1x" not "3x"..... but that seems to make sense. I will continue wit=h that route>=20> The docs on "Searching - Combining" separated the query items with a comma=....>=20> Grouping doesn't sound like it'll work because I'm searching in just one f=ield.>=20>=20>=20>=20> On Saturday, March 5, 2016 10:43 PM, Stuart Tremain w=rote:>=20>=20> What about using + in the query ?>=20> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONS=word=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12+19]>=20>=20> Kind regards>=20> Stuart Tremain> IDFK Web Developments> AUSTRALIA> webdna@idfk.com.au>=20>=20>=20>=20>=20>> On 6 Mar 2016, at 15:36, Rich Kwas wrote:>>=20>> The docs reference "ww" in "Searching>Word Breaks">>=20>> I use the ww to search within the field where I separate the sections wit=h a "+" sign.>> Been doing that all along and it work fine searching for the sections one= by one.>>=20>> =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 characte=rs)>>=20>> Descriptionword=3Dww looks for "graphic" and will not find it inside phra=ses 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>>=20>> Trying just "wo" doesn't work at all>>=20>> I get every listing back with this (144 total ) .....>> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTION=Sword=3Dwo&SECTIONSdata=3D12,31]>>=20>> Adding "rq" to Sectionsdata returns 0 items>> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTION=Sword=3Dwo&SECTIONSdatarq=3D12,31]>>=20>> :(>>=20>>=20>>=20>>=20>> On Saturday, March 5, 2016 10:02 PM, Stuart Tremain w=rote:>>=20>>=20>> Rich>>=20>> I think that you may have success with: SECTIONSword=3Dwo, I can=E2=80=99=t see any reference in the docs to ww.>>=20>> Separate the words and "or" them together (at least one must match - defa=ult option for text). Search for 3 words using wo will match if any one of t=hem matches.>>=20>>=20>> Kind regards>>=20>> Stuart Tremain>> IDFK Web Developments>> AUSTRALIA>> webdna@idfk.com.au>>=20>>=20>>=20>>=20>>=20>>> On 6 Mar 2016, at 09:11, Rich Kwas wrote:>>>=20>>> Am I dong this right?>>> Seems so based on the docs....>>>=20>>> I have items that appear multiple sections.>>>=20>>> Their section location in the db is stored as:>>> +33+34+35+12+17+19+18+20+21+83+84+>>>=20>>> I want to find all items that appear in either section 12 or 19>>>=20>>> This is my code....>>> [search db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIO=NSword=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12,19]>>>=20>>> Section 12 has 87 items>>> Section 19 has 7 items>>>=20>>> If I use "&SECTIONSdatarq=3D12" I get back 87 which is correct>>> If I use "&SECTIONSdatarq=3D19" I get back 7 which is correct>>>=20>>> If I use "&SECTIONSdatarq=3D12,19" I get back 141 which is the total of a=ll items,and should be just 94.>>>=20>>> I've tried it with "rq" and without "rq, same result.>>>=20>>>=20>>>=20>>> I'm using vers 6.2 on Windows Server 2008>>>=20>>>=20>>>=20>>>=20>>>=20>>> --------------------------------------------------------- This message i=s sent to you because you are subscribed to the mailing list . To unsubscrib=e, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Report=ing: support@webdna.us>>=20>> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe=, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti=ng: support@webdna.us>>=20>>=20>> --------------------------------------------------------- This message is= sent to you because you are subscribed to the mailing list . To unsubscribe=, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporti=ng: support@webdna.us>=20> --------------------------------------------------------- This message is s=ent to you because you are subscribed to the mailing list . To unsubscribe, E=-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us>=20>=20> --------------------------------------------------------- This message is s=ent to you because you are subscribed to the mailing list . To unsubscribe, E=-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug Reporting:= support@webdna.us--Apple-Mail-0842CB80-49AD-442D-A452-4CEDACDBE07BContent-Type: text/html;charset=utf-8Content-Transfer-Encoding: quoted-printable