Re: [WebDNA] Combining searches

This WebDNA talk-list message is from

2016

It keeps the original formatting. numero = 112601
interpreted = N
texte = 183--Apple-Mail=_13416388-6EFA-4AB2-A773-E6FBCF8DD3A9Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8What about using + in the query ?[search =db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dw=w&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12+19]Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au> 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 =with 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 =characters)>=20> 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>=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&SECTIONSword=3Dw=o&SECTIONSdata=3D12,31]>=20> Adding "rq" to Sectionsdata returns 0 items> [search =db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dw=o&SECTIONSdatarq=3D12,31]>=20> :(>=20>=20>=20>=20> On Saturday, March 5, 2016 10:02 PM, Stuart Tremain = wrote:>=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 - =default option for text). Search for 3 words using wo will match if any =one of them 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&SECTIONSword=3Dw=w&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 all 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 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 Reporting: =support@webdna.us > --------------------------------------------------------- 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 Reporting: =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 Reporting: =support@webdna.us--Apple-Mail=_13416388-6EFA-4AB2-A773-E6FBCF8DD3A9Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8What about using + in the query ?

[search =db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECT=IONSword=3Dww&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12+19]

Kind =regards

Stuart =Tremain

IDFK Web Developments

AUSTRALIA

webdna@idfk.com.au

On 6 Mar 2016, at 15:36, Rich Kwas <richkwasniewski@yahoo.com> 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 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 characters)

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" doesn't work at all

I get every listing =back with this (144 total ) .....
[search =db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECT=IONSword=3Dwo&SECTIONSdata=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 Tremain <webdna@idfk.com.au> =wrote:

Rich

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 - default option =for text). Search for 3 words using wo will match if any one of them =matches.

=
Kind =regards

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

On 6 Mar 2016, at 09:11, Rich Kwas <richkwasniewski@yahoo.com>=; 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+83+84+

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

This is my =code....
[search =db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECT=IONSword=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 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/l=ist/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=_13416388-6EFA-4AB2-A773-E6FBCF8DD3A9--. 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)

183--Apple-Mail=_13416388-6EFA-4AB2-A773-E6FBCF8DD3A9Content-Transfer-Encoding: quoted-printableContent-Type: text/plain;charset=utf-8What about using + in the query ?[search =db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dw=w&SECTIONSwbrk=3D+&SECTIONSdatarq=3D12+19]Kind regardsStuart TremainIDFK Web DevelopmentsAUSTRALIAwebdna@idfk.com.au> 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 =with 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 =characters)>=20> 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>=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&SECTIONSword=3Dw=o&SECTIONSdata=3D12,31]>=20> Adding "rq" to Sectionsdata returns 0 items> [search =db=3D^/rs2k/products.db&eqVisibledatarq=3DT&asSKUsort=3D1&SECTIONSword=3Dw=o&SECTIONSdatarq=3D12,31]>=20> :(>=20>=20>=20>=20> On Saturday, March 5, 2016 10:02 PM, Stuart Tremain = wrote:>=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 - =default option for text). Search for 3 words using wo will match if any =one of them 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&SECTIONSword=3Dw=w&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 all 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 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 Reporting: =support@webdna.us > --------------------------------------------------------- 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 Reporting: =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 Reporting: =support@webdna.us--Apple-Mail=_13416388-6EFA-4AB2-A773-E6FBCF8DD3A9Content-Transfer-Encoding: quoted-printableContent-Type: text/html;charset=utf-8What about using + in the query ?