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 = 112577
interpreted = N
texte = 159That=92t new territory for me.So I tried like this but it did not work[/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!][/!]negroup1datarq=3D8&negroup2datarq=3D10&[!]Actually all 8 and 10 results where included.Is it supposed to be[/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!]or[/!]group1=3Dprogressdata&group2=3Dprogressdata&[!]/Palle> On 6. feb. 2016, at 17.10, Terry Wilson
wrote:>=20> 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:>=20> "Searching the same field in two different ways>=20> 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:>=20> group1field=3Dzipcode&group2field=3Dzipcode">=20>=20> Another solution would be to use=20>=20> [founditems]> [hideif [db_progressdata]=3D8]>=20> ---results--->=20> [/hideif]> [/founditems]>=20> In the above, if you need to count them up, [numfound] won't work, so =add a counter to the results area>=20> Terry W>=20>=20> On Feb 6, 2016, at 7:12 AM, Palle Bo Nielsen = wrote:>=20>> 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>=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---------------------------------------------------------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:
159That=92t new territory for me.So I tried like this but it did not work[/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!][/!]negroup1datarq=3D8&negroup2datarq=3D10&[!]Actually all 8 and 10 results where included.Is it supposed to be[/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!]or[/!]group1=3Dprogressdata&group2=3Dprogressdata&[!]/Palle> On 6. feb. 2016, at 17.10, Terry Wilson wrote:>=20> 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:>=20> "Searching the same field in two different ways>=20> 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:>=20> group1field=3Dzipcode&group2field=3Dzipcode">=20>=20> Another solution would be to use=20>=20> [founditems]> [hideif [db_progressdata]=3D8]>=20> ---results--->=20> [/hideif]> [/founditems]>=20> In the above, if you need to count them up, [numfound] won't work, so =add a counter to the results area>=20> Terry W>=20>=20> On Feb 6, 2016, at 7:12 AM, Palle Bo Nielsen = wrote:>=20>> 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>=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---------------------------------------------------------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.
Palle Bo Nielsen
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:
Mac 2.1b2 speed (1997)
Add a field to the error log? (1997)
[cart] number range ?? (2001)
[WebDNA] Cookie behavior (2010)
access denied problem (1997)
HELP! Search finding too much! (1998)
OSX 10.2.6/iTools 7.0/WebDNA 5.0 installation (2003)
RE: Answer: WebDelivery downloads alias, not original ? (1997)
help testing quicktime delivery (1997)
Dynamically Generated Pages & WC? (2000)
WC 2.0 frames feature (1997)
Configuring E-mail (1997)
Using [showif] within [lineitems] [code fragment] (2000)
RE: ShowNext Command (1997)
Pithy questions on webcommerce & siteedit (1997)
Newbie Tax Question (1997)
A Global Variable (1997)
bug in wn searching NT version? (1997)
[WriteFile] problems (1997)
[WebDNA] Windows WebDNA Editor (2009)