Re: [WebDNA] Combining searches

This WebDNA talk-list message is from

2016


It keeps the original formatting.
numero = 112602
interpreted = N
texte = 184 --Apple-Mail=_25DAE11D-0FD6-477D-85CF-11BC99FB73E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii We talked recently about using group fields to search on the same field = twice. Do that here, once for +12+ and once for +19+. No need to define = word breaks since you're just looking for a string. Check the docs or = recent messages for the details on using group fields. Terry On Mar 5, 2016, at 2:11 PM, Rich Kwas wrote: > 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 --Apple-Mail=_25DAE11D-0FD6-477D-85CF-11BC99FB73E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii We = talked recently about using group fields to search on the same field = twice. Do that here, once for +12+ and once for +19+. No need to define = word breaks since you're just looking for a string. Check the docs or = recent messages for the details on using group = fields.

Terry

On Mar 5, = 2016, at 2:11 PM, 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 to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/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 --Apple-Mail=_25DAE11D-0FD6-477D-85CF-11BC99FB73E2-- . Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Combining searches (Terry Wilson 2016)
  2. Re: [WebDNA] Combining searches (Rich Kwas 2016)
  3. Re: [WebDNA] Combining searches (Terry Wilson 2016)
  4. Re: [WebDNA] Combining searches (Stuart Tremain 2016)
  5. Re: [WebDNA] Combining searches (Rich Kwas 2016)
  6. Re: [WebDNA] Combining searches (Stuart Tremain 2016)
  7. [WebDNA] Combining searches (Rich Kwas 2016)
  8. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  9. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  10. Re: [WebDNA] Combining searches with blank and zero values? (Ronald Kirkland 2011)
  11. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  12. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  13. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  14. Re: [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
  15. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  16. Re: [WebDNA] Combining searches with blank and zero values? (Dan Strong 2011)
  17. Re: [WebDNA] Combining searches with blank and zero values? (Govinda 2011)
  18. [WebDNA] Combining searches with blank and zero values? (William DeVaul 2011)
184 --Apple-Mail=_25DAE11D-0FD6-477D-85CF-11BC99FB73E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=us-ascii We talked recently about using group fields to search on the same field = twice. Do that here, once for +12+ and once for +19+. No need to define = word breaks since you're just looking for a string. Check the docs or = recent messages for the details on using group fields. Terry On Mar 5, 2016, at 2:11 PM, Rich Kwas wrote: > 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 --Apple-Mail=_25DAE11D-0FD6-477D-85CF-11BC99FB73E2 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=us-ascii We = talked recently about using group fields to search on the same field = twice. Do that here, once for +12+ and once for +19+. No need to define = word breaks since you're just looking for a string. Check the docs or = recent messages for the details on using group = fields.

Terry

On Mar 5, = 2016, at 2:11 PM, 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 to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/l= ist/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 --Apple-Mail=_25DAE11D-0FD6-477D-85CF-11BC99FB73E2-- . 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:

E-mailer application times out (1998) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Cookies (1999) Multiple prices (1997) ShowNext Command (1997) Editing the search string (1997) Problem with CC problem ? (1997) WebCat2: Found Items syntax, etc. (1997) Limitations on fields? Server is crashing (1997) Re:Signal Raised (1997) Date Question (2002) Setting shipCost -- thanks! (1999) Making Thumbnail Graphics (1997) Bug? (1997) WebCatReference pages partly blank/empty on Webcat 3.0.7 NT (2000) WebCat2b12--[searchstring] bug (1997) using showpage and showcart commands (1996) shipping costs (1997) Running 2 two WebCatalog.acgi's (1996) Emailer help....! (1997)