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 = 159 That=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 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:
159 That=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 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:
StoreBuilder Q's (2003)
Showif, Hideif reverse logic ? (1997)
WebCat editing, SiteGuard & SiteEdit (1997)
This message couldn't reach the list! (multi-column (1998)
Dreamweaver extensions [reprise] (2000)
Notepad problems (1998)
More news on 5.0 (2003)
Re:Searching for ALL / empty form field (1997)
Who is doing sign-ups-got it (1998)
[OT] Connect to MySQL (2004)
encryption (2003)
Resume Catalog ? (1997)
make updates in a temporary database (2004)
[searchString] (1997)
Applescript error (1998)
Multiple Ad databases? (1997)
Summary search -- speed (1997)
Emailer (WebCat2) (1997)
More Applescript (1997)
RE: Languages (1997)