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:

How to include weather (2000) Protecting Realms (1998) DB permission issues (2004) File Upload (1997) Credit card types (1997) Next X hits (1996) WebCat2b12 CGI Mac -- Problems propagating the cart through frames...still (1997) possible, WebCat2.0 and checkboxes-restated (1997) Nesting format tags (1997) Nested tags count question (1997) WC2b15 - [HTMLx]...[/HTMLx] problems (1997) Applescript error (1998) multiple search commands (1997) Multi-processor Mac info ... (1997) Clean Code: Rules for inserting keyboard returns? (1997) PSC recommends what date format yr 2000??? (1997) won't serve .tpl (2000) WebCat/Typhoon Status under Windows (1998) How To question on setting up downloads (1997) Encyption mail was Suggestions for Topics ... (1998)