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 breakthem 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 notboth.| >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 thenon-_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 andplaces| >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 breakthem 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 notboth.| >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 thenon-_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 andplaces| >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:
SPAM is SPAM is SPAM.... Smith Micro - no competition (2000)
Multiple security dbs (1997)
Server Load (2000)
Late on Friday.... brain fried (2002)
requiredfields (2002)
test (2004)
Help Encrypt/Decrypt eMail (2003)
Creating main- and sub-category search (1997)
Ads.db (1997)
Grep question [parsing variables] problem (2003)
[SHOWIF] PROBLEM (2000)
WebDNA 6.0 NOT Configured fot accept domain (2006)
Firesite and WebCat (1999)
NT considerations (1997)
(2003)
Polls (2003)
Download Question (1997)
[WebDNA] Commerce tags clarification (2015)
WebCatalog Q & A pages (1997)
Bug Report, maybe (1997)