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:

    
  1. Re: Odd search results, or odd programmer, not sure which... (Kenneth Grome 2002)
  2. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  3. Re: Odd search results, or odd programmer, not sure which... (Brian Fries 2002)
  4. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  5. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  6. Re: Odd search results, or odd programmer, not sure which... (Inkblot Media 2002)
  7. Re: Odd search results, or odd programmer, not sure which... (Inkblot Media 2002)
  8. Re: Odd search results, or odd programmer, not sure which... (Gary Krockover 2002)
  9. Re: Odd search results, or odd programmer, not sure which... (Glenn Busbin 2002)
  10. 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:

Can someone help? (2000) ReadDateFormat bug in 3.x (1998) WebCat2b13MacPlugIn - [shownext method=post] ??? (1997) No Wanna Duppys (1998) Return records from another (1997) An easy one (1999) Formulas.db (2003) RE: WebCat name recognition (was MacFinder -- a new WebDNAweb site) (1998) Rename file (2005) calculating tax rates, mail order solutions and version 2 (1997) Keep away (1997) OK, here's a new one (2002) WebCat2 as a chat server? (1997) ExclusiveLock (2000) Calculating days, hours, minutes ago (2004) RE: groups and [ShowNext] (1997) RE: webcat error log (1998) Snake Bites (1997) contextual shownext (1998) Don't tick me off :) [elaspedtime] (1997)