Re: Odd search results, or odd programmer, not sure which...

This WebDNA talk-list message is from

2002

It keeps the original formatting. numero = 42876
interpreted = N
texte = 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=_openSince location and group1 are different identifiers, both selection parameters will be executed.- brianAt 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/ 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)

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=_openSince location and group1 are different identifiers, both selection parameters will be executed.- brianAt 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/ Brian Fries

DOWNLOAD WEBDNA NOW!

Re: Odd search results, or odd programmer, not sure which...

2002

Top Articles:

Related Readings: