Re: Odd search results, or odd programmer, not sure which...
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42878
interpreted = N
texte = I should of remembered this, thanks Brian. I guess our answer was to break them down into multiple groups, which is going to work out better anyways.Thanks again, GK | The [search] context only supports one selection parameter for each | DB field. You cannot test the same field directly twice in the same | search. | | However, you can get around this limitation by using group fields and | only specifying one field for the group. | | Using your example, you could do the following: | | &wnlocationdata=HE&group1field=location&wogroup1datarq=_open | | | Since location and group1 are different identifiers, both | selection parameters will be executed. | | - brian | | | At 12:35 PM 8/23/02, Gary Krockover wrote: | >Hey all, | > | >database has a field, named location. In that field, some examples: | >HE170 | >HE170_open | >FBC170 | >FBC170_open | >TOP1170 | >TOP1170_open | >DMR171 | >DMR171_open | > | >etc... | > | >Now, I need a search that will show only those records that contain the | >_open and do *not* contain HE. I can do one or the other, but not both. | >In fact, trying both produces some strange results: | > | >....&wnlocationdata=HE&wolocationdatarq=_open | >will hide the records with HE, but will also hide the records with _open | >(shouldn't wo show those, not hide them?). | > | >....&wolocationdatarq=_open&wnlocationdata=HE | >will show everything, _open, non-_open, HE and other records. | > | >....&wolocationdatarq=_open&wnlocationdata=HE&allreq=T | >will show all HE records, and all _open records. It will hide the non-_open | >records for all but the HE's. (if that's clear...) | > | >....&wolocationdatarq=_open&nelocationdatarq=HE | >shows the exact same as above. | > | >....&wolocationdatarq=_open&nelocationdata=HE | >shows the same as above, and interestingly, ignores my sort order and places | >all the HE170_open to the top, then the rest. | > | >Any combinations that I'm missing? I have flushed db's between tries as | >well. No funky characters in the db either. Any other ideas? | > | >I'm assuming that the numbers in the words are giving it the fits. Do I | >recall a ww search, wordswith perhaps? I don't see it in the docs but | >will try it now. | > | >GK | >Gary Krockover | >Webmaster | >Internet Gateway | >www.thegateway.net | >(512) 930-1022 | > | > | >------------------------------------------------------------- | >This message is sent to you because you are subscribed to | > the mailing list
. | >To unsubscribe, E-mail to: | >To switch to the DIGEST mode, E-mail to | > | >Web Archive of this list is at: http://search.smithmicro.com/ | | | ------------------------------------------------------------- | This message is sent to you because you are subscribed to | the mailing list . | To unsubscribe, E-mail to: | To switch to the DIGEST mode, E-mail to | Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- Re: Odd search results, or odd programmer, not sure which... (Kenneth Grome 2002)
- Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
- Re: Odd search results, or odd programmer, not sure which... (Brian Fries 2002)
- Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
- Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
- Re: Odd search results, or odd programmer, not sure which... (Inkblot Media 2002)
- Re: Odd search results, or odd programmer, not sure which... (Inkblot Media 2002)
- Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
- Re: Odd search results, or odd programmer, not sure which... (Glenn Busbin 2002)
- Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
|
I should of remembered this, thanks Brian. I guess our answer was to break them down into multiple groups, which is going to work out better anyways.Thanks again, GK | The [search] context only supports one selection parameter for each | DB field. You cannot test the same field directly twice in the same | search. | | However, you can get around this limitation by using group fields and | only specifying one field for the group. | | Using your example, you could do the following: | | &wnlocationdata=HE&group1field=location&wogroup1datarq=_open | | | Since location and group1 are different identifiers, both | selection parameters will be executed. | | - brian | | | At 12:35 PM 8/23/02, Gary Krockover wrote: | >Hey all, | > | >database has a field, named location. In that field, some examples: | >HE170 | >HE170_open | >FBC170 | >FBC170_open | >TOP1170 | >TOP1170_open | >DMR171 | >DMR171_open | > | >etc... | > | >Now, I need a search that will show only those records that contain the | >_open and do *not* contain HE. I can do one or the other, but not both. | >In fact, trying both produces some strange results: | > | >....&wnlocationdata=HE&wolocationdatarq=_open | >will hide the records with HE, but will also hide the records with _open | >(shouldn't wo show those, not hide them?). | > | >....&wolocationdatarq=_open&wnlocationdata=HE | >will show everything, _open, non-_open, HE and other records. | > | >....&wolocationdatarq=_open&wnlocationdata=HE&allreq=T | >will show all HE records, and all _open records. It will hide the non-_open | >records for all but the HE's. (if that's clear...) | > | >....&wolocationdatarq=_open&nelocationdatarq=HE | >shows the exact same as above. | > | >....&wolocationdatarq=_open&nelocationdata=HE | >shows the same as above, and interestingly, ignores my sort order and places | >all the HE170_open to the top, then the rest. | > | >Any combinations that I'm missing? I have flushed db's between tries as | >well. No funky characters in the db either. Any other ideas? | > | >I'm assuming that the numbers in the words are giving it the fits. Do I | >recall a ww search, wordswith perhaps? I don't see it in the docs but | >will try it now. | > | >GK | >Gary Krockover | >Webmaster | >Internet Gateway | >www.thegateway.net | >(512) 930-1022 | > | > | >------------------------------------------------------------- | >This message is sent to you because you are subscribed to | > the mailing list . | >To unsubscribe, E-mail to: | >To switch to the DIGEST mode, E-mail to | > | >Web Archive of this list is at: http://search.smithmicro.com/ | | | ------------------------------------------------------------- | This message is sent to you because you are subscribed to | the mailing list . | To unsubscribe, E-mail to: | To switch to the DIGEST mode, E-mail to | Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Gary Krockover
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:
Protecting Images (2003)
SetHeader (1997)
[ConvertChars] problem (1997)
BBEdit and WebCatalog 2.0? (1997)
ooops...WebCatalog [FoundItems] Problem - LONG - (1997)
[FileInfo] on a remote file (2000)
[WebDNA] Grep everything and replace with asterisks? (2010)
StoreBuilder v4.0.2 Question (2001)
Shared conversion under WebTen (1998)
Simple way to create unique SKU (1997)
different show next (1997)
Webcat 2.0.1 date math bug -> Crash! (1997)
Text data with spaces in them... (1997)
[TEST] - Please Ignore (2000)
[url] link (1998)
Make sure I understand this??? (1997)
textarea inputs and returns (1999)
[WebDNA] Installing WebDNA 7 on OSX Mavericks Server - Instructions (2014)
OT Pager notification of completed orders (1998)
showing *all* name/value pairs with [search] (2003)