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:
Search Order? (2000)
gateway application timeouts (1998)
Download Question (1997)
OT: ZIP & SIT files on OSX (2002)
oops private message leaked into talk list (1997)
Attn: Bug in GeneralStore example b15 (1997)
Has ANYONE gotten the [object] context to work with Java(OSX) ??? HELP! (2002)
Ruby on Rails (was Looping Search) (2006)
Sending Email (2004)
fixed date problem (1997)
RAM to disk (2002)
File Uploads... (1997)
shipcost (1997)
2cd pair of eyes (2003)
[OT] Deploying XRAID (2003)
Re:Copyright ? (1997)
search vs lookup (1998)
reversing the effects of [url] (1997)
Preventing Merchant Settling ? (1997)
[WebDNA] Triggers issue, or sendmail? (2012)