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:
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)