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 = 112576
interpreted = N
texte = 158 My bad, it made wrong syntax [/!]group1field=3Ddb_progress&group2field=3Ddb_progress&[!] [/!]negroup1datarq=3D8&negroup2datarq=3D10&[!] Fixed it. Thanks a lot Terry /Palle > On 6. feb. 2016, at 18.56, Palle Bo Nielsen
= wrote: >=20 > That=92t new territory for me. >=20 > So I tried like this but it did not work >=20 > [/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!] > [/!]negroup1datarq=3D8&negroup2datarq=3D10&[!] >=20 > Actually all 8 and 10 results where included. >=20 > Is it supposed to be >=20 > [/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!] > or > [/!]group1=3Dprogressdata&group2=3Dprogressdata&[!] >=20 >=20 > /Palle >=20 >=20 >> 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 >=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 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:
158 My bad, it made wrong syntax [/!]group1field=3Ddb_progress&group2field=3Ddb_progress&[!] [/!]negroup1datarq=3D8&negroup2datarq=3D10&[!] Fixed it. Thanks a lot Terry /Palle > On 6. feb. 2016, at 18.56, Palle Bo Nielsen = wrote: >=20 > That=92t new territory for me. >=20 > So I tried like this but it did not work >=20 > [/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!] > [/!]negroup1datarq=3D8&negroup2datarq=3D10&[!] >=20 > Actually all 8 and 10 results where included. >=20 > Is it supposed to be >=20 > [/!]group1field=3Dprogressdata&group2field=3Dprogressdata&[!] > or > [/!]group1=3Dprogressdata&group2=3Dprogressdata&[!] >=20 >=20 > /Palle >=20 >=20 >> 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 >=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 to the mailing list . To unsubscribe, E-mail to: archives: http://mail.webdna.us/list/talk@webdna.us Bug 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:
WebMerchant Config problems (2000)
PCS Frames (1997)
Mac v. NT (1998)
Or Operator (2005)
'does not contain' operator needed ... (1997)
(2000)
Global variables are not always global ... (2000)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
[/application] error? (1997)
[WriteFile] problems (1997)
webcat 3.06f on Linux keeps dying (1999)
Can't use old cart file (was One more try) (1997)
Emailer update for Mac? (1998)
WebCatalog sales (1997)
combining strings (1997)
Searchable WebCat (etc.) Docs ? (1997)
Almost a there but..bye bye NetCloak (1997)
HELP WITH DATES (1997)
Problems passing [SKU] with $Replace in 2.0 (1997)
ShowIf variables (1997)