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:

CSV import suggestions (2007) WebCat2: Items xx to xx shown, etc. (1997) Make sure I understand this??? (1997) GuestBook example (1997) WCS Newbie question (1997) [WebDNA] Old Problem, the exclamation point (2014) OT-Load balance (2004) possible, WebCat2.0 and checkboxes-restated (1997) converchars in sendmail context.... (2004) Banners and sort of random display (1997) can WC render sites out? (1997) P3P and IE 6 (2004) SERIAL NUMBER PROBLEM *AGAIN*!!! (1998) Document Contains No Data, Blank Pages with b4, b6 mac! (1999) [searchString] (1997) WCS Newbie question (1997) webcat database helper question (2000) Ariba XML support help needed (2004) form data submission gets truncated (1997) OT-ssh help (2004)