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 = 157Use 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 waysSometimes 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 areaTerry WOn 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug Reporting: support@webdna.us.
Associated Messages, from the most recent to the oldest:
157Use 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 waysSometimes 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 areaTerry WOn 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 tothe mailing list .To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.usBug 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:
4.5.1 (2003)
Online reference (1997)
WC Database Format (1997)
[WebDNA] Non-numbers entered into a field that asks for a number (2008)
[no_cache]?! (2000)
Close-to Comparison Code (1998)
grabbing xml data with webcat (was: Posting XML data to (2002)
Simple way to create unique SKU (1997)
Authorize.net setup (2002)
WebDNA tags in WebMerchant email templates ... (1997)
Summary layout (1997)
RE: ANother SHOWIF problem (1997)
[WebDNA] Installing Windows CICADA under IIS7/2008 Server Enterprise 64bit (2009)
[WebDNA] Does anyone host webdna sites? (2016)
writing db to disk (1997)
PCS Emailer's role ? (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
WebCat control of Print (2001)
Error Log.db --however (1997)
WC2.0 Memory Requirements (1997)