Re: [WebDNA] Trying to search for two values within one criteria...
This WebDNA talk-list message is from 2016
It keeps the original formatting.
numero = 112575
interpreted = N
texte = 157 Use a group field to search two different ways on one field. There are = two ways to use group: to search multiple fields at once, and to search = one field in two different ways. Here's from the docs: "Searching the same field in two different ways Sometimes you need to compare a value two different ways, but the search = parameter will only accept a fieldname once. In this case, create two = group fields like this: group1field=3Dzipcode&group2field=3Dzipcode" Another solution would be to use=20 [founditems] [hideif [db_progressdata]=3D8] ---results--- [/hideif] [/founditems] In the above, if you need to count them up, [numfound] won't work, so = add a counter to the results area Terry W On Feb 6, 2016, at 7:12 AM, Palle Bo Nielsen
= wrote: > Hi all >=20 > The code below works fine, but I need to set the to = filter two values. Right now it deselects any field with the value 10. I = need for it to deselect any field with the numbers 8 and 10. >=20 > So I thought it could look like this example, but I won=92t work - how = is that? >=20 > [/!]nedb_progressdatarq=3D8,10&[!] >=20 >=20 >=20 > =97 original code which works with the value 10 -- >=20 > [search db=3D/somepath/some.db&[!] >=20 > [/!]eqdb_publishdatarq=3D1&[!] > [/!]nedb_progressdatarq=3D10&[!] <<<<<< ISSUE > [/!]max=3D[issue_search_length]&[!] >=20 > [/!][showif [direction]^direction]dedb_indexSort=3D1&[/showif][!] > [/!][showif [direction]=3Dhead]asdb_headlinesort=3D1&[/showif][!] > [/!][showif [direction]=3Didid]dedb_indexsort=3D1&[/showif][!] > [/!][showif [direction]=3Dprog]dedb_progresssort=3D1&[/showif][!] > [/!][showif [direction]=3Dprio]asdb_prioritysort=3D1&[/showif][!] > [/!][showif [direction]=3Dtype]dedb_typesort=3D1&[/showif][!] > [/!][showif [direction]=3Dcate]dedb_categorysort=3D1&[/showif][!] >=20 > [/!]db_indextype=3Dnum&[!] > [/!]allreqd=3DT&[!] > [/!]AllHit=3D1[!] > [/!]startat=3D[start]] >=20 > [founditems]--------------------------------------------------------- > 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 --------------------------------------------------------- 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 .
Associated Messages, from the most recent to the oldest:
157 Use a group field to search two different ways on one field. There are = two ways to use group: to search multiple fields at once, and to search = one field in two different ways. Here's from the docs: "Searching the same field in two different ways Sometimes you need to compare a value two different ways, but the search = parameter will only accept a fieldname once. In this case, create two = group fields like this: group1field=3Dzipcode&group2field=3Dzipcode" Another solution would be to use=20 [founditems] [hideif [db_progressdata]=3D8] ---results--- [/hideif] [/founditems] In the above, if you need to count them up, [numfound] won't work, so = add a counter to the results area Terry W On Feb 6, 2016, at 7:12 AM, Palle Bo Nielsen = wrote: > Hi all >=20 > The code below works fine, but I need to set the to = filter two values. Right now it deselects any field with the value 10. I = need for it to deselect any field with the numbers 8 and 10. >=20 > So I thought it could look like this example, but I won=92t work - how = is that? >=20 > [/!]nedb_progressdatarq=3D8,10&[!] >=20 >=20 >=20 > =97 original code which works with the value 10 -- >=20 > [search db=3D/somepath/some.db&[!] >=20 > [/!]eqdb_publishdatarq=3D1&[!] > [/!]nedb_progressdatarq=3D10&[!] <<<<<< ISSUE > [/!]max=3D[issue_search_length]&[!] >=20 > [/!][showif [direction]^direction]dedb_indexSort=3D1&[/showif][!] > [/!][showif [direction]=3Dhead]asdb_headlinesort=3D1&[/showif][!] > [/!][showif [direction]=3Didid]dedb_indexsort=3D1&[/showif][!] > [/!][showif [direction]=3Dprog]dedb_progresssort=3D1&[/showif][!] > [/!][showif [direction]=3Dprio]asdb_prioritysort=3D1&[/showif][!] > [/!][showif [direction]=3Dtype]dedb_typesort=3D1&[/showif][!] > [/!][showif [direction]=3Dcate]dedb_categorysort=3D1&[/showif][!] >=20 > [/!]db_indextype=3Dnum&[!] > [/!]allreqd=3DT&[!] > [/!]AllHit=3D1[!] > [/!]startat=3D[start]] >=20 > [founditems]--------------------------------------------------------- > 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 --------------------------------------------------------- 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 .
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:
Re1000002: Setting up shop (1997)
Server Load (2000)
Help formatting search results w/ table (1997)
japanese characters (1997)
Counting Inventory (2003)
WebCatalog2 Feature Feedback (1996)
Emailer (WebCat2) (1997)
[WebDNA] [listwords] and [index] (2009)
two unique banners on one page (1997)
Setting up shop (1997)
IE-caching (1998)
Web Catalog 2 demo (1997)
Calculating Total QTY (1998)
Multiple cart additions (1997)
Help! WebCat2 bug (1997)
Roundup function? (1997)
sandboxes with 6.0 (2004)
NT License trade for Mac (2000)
form data submission gets truncated (1997)
Shipping Calculation Problem (1997)