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:

Looking up two prices in database? (1997) Alternating colors (1997) calculating time (2002) Calendar (1997) Setting up WebCatalog with Retail Pro data (1996) Replace context problem ... and answers (1997) PCS Frames (1997) Problems searching from a FORM (1997) Fun with dates (1997) listfiles-looking for slick solution (1997) Protect vs Authenicate (1997) useful guidelines =] vs !] (2007) HELP WITH DATES (1997) Checking two required fields (1998) [OT] HTML render (2003) Answer: WebDelivery downloads alias, not original ? (1997) Hiding Brands (2004) Faxing orders in place of email (1997) fieldnamesdir=ra equivalent for [sql] (2002) Weird Cookie Problem - your answer (2007)