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:

Suddenly can't see files... (2000) emailer w/F2 (1997) WebCommerce: Folder organization ? (1997) database problems (1999) Format of Required fields error message (1997) search form problem.. (1997) 2.0.1: Shopping Carts deleted after 1 hour (1997) all records returned. (1997) WebCatalog can't find database (1997) [format xs] freeze (1997) Online reference (1997) WebCat2 - [format thousands] (1997) URGENT: WebCatalog 2.0 (1998) Email notification to one of multiple vendors ? (1997) [WebDNA] WebDNA restart script (2015) Protect (1997) taxrate - off by 1 cent (1997) Sendmail on OSX/Communigate Pro (2002) Dummy Form Variables Needed (2000) [include file=filename.inc&strip=t] (2002)