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:
build a select list from a db search (2004)
WebCat, switching from NT to OSX (2003)
WebSTAR 2.1 freezes my Mac (1997)
Ok here is a question? (1997)
Can you do this??? and other stuff (1997)
Shopping problems with 2.1b3 acgi (1997)
FYI: virus alert (1996)
Updating a database once per day - An example (1998)
PIXO support (1997)
Using [Include] Context (1999)
WCf2 and nested tags (1997)
declined orders webmerchant not showing up? (2005)
Unix Timestamp using WebDNA [code req] (2003)
Unceremonious Unwanted Unsubscription (1999)
[OT] Communigate List (2003)
answers - opinions? (1998)
PROBLEM (1997)
Lot entry (1999)
Version 2.1.3 changes ... (1998)
Cool new site (1996)