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:
Date problems-more (1997)
Sending Faxes (2003)
Serious bug writing to a database ... (2002)
Invoice in another window (1998)
A question on sub-categories (1997)
Help name our technology! (1997)
is this how [break] works? (1998)
Problems passing [SKU] with $Replace in 2.0 (1997)
New Webcatalog for Mac (1997)
Reversed words (1997)
bad time on my email was [url] issue (2000)
Can this be done? (1997)
[LOOKUP] (1997)
Add more fields to an existent data base (1997)
New servers and new inline cache (1997)
[WebDNA] Foreign characters (2009) (2009)
Integration with SQL (1997)
Weird Math and SV (1997)
Using Communigate Pro on Mac OS X Server (2000)
[OT] Disable/enable field (2003)