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:
[WebDNA] [MATH] & formatting (2015)
PSC recommends what date format yr 2000??? (1997)
IIS4/WebCat3.0 Authentication (1999)
Cart Question (1998)
process SSI (1998)
Random/Odd/Even Listings (2005)
Extended [ConvertChars] (1997)
vs (1997)
[format] minus figures (2003)
What am I missing (1997)
Happy New Year (2002)
Return records from another (1997)
lookup and two records? (1997)
[TaxableTotal] - not working with AOL and IE (1997)
could someone please try this - it's very quick and easy (2000)
Carts & Refering URLs (1997)
CommandSecurity? (1997)
BBEdit and WebCatalog 2.0? (1997)
Re[2]: POSTing to a secure server ... (2000)
foreign character sets and conversions (1998)