Re: Odd search results, or odd programmer, not sure which...
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 42870
interpreted = N
texte = Hey Gary,I would do a search for those records that contain the 'open' and then use a [hideif] of the 'if then' to remove those that contain the 'HE':[search db=some.db&woLOCATIONSdatarq=_open&LOCATIONSword=ss] [founditems]-- hideif -- [hideif [locations]^HE]-- if then -- [If ([locations]^HE)] [Else]what ever you want to do here when LOCATIONS did not contain HE[/Else] [/If]Just my thoughts. ------------------------------------------------------------ Ronald Kirkland - President Inkblot Media - Internet Solutions Experts Phone: 949.400.4456 * FAX: 949.654.0269 Visit: http://www.inkblotmedia.com ------------------------------------------------------------ ----- Original Message ----- From: Gary Krockover
To: WebCatalog Talk Sent: Friday, August 23, 2002 10:35 AM Subject: Odd search results, or odd programmer, not sure which... > 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)
|
Hey Gary,I would do a search for those records that contain the 'open' and then use a [hideif] of the 'if then' to remove those that contain the 'HE':[search db=some.db&woLOCATIONSdatarq=_open&LOCATIONSword=ss] [founditems]-- hideif -- [hideif [locations]^HE]-- if then -- [If ([locations]^HE)] [Else]what ever you want to do here when LOCATIONS did not contain HE[/Else] [/If]Just my thoughts. ------------------------------------------------------------ Ronald Kirkland - President Inkblot Media - Internet Solutions Experts Phone: 949.400.4456 * FAX: 949.654.0269 Visit: http://www.inkblotmedia.com ------------------------------------------------------------ ----- Original Message ----- From: Gary Krockover To: WebCatalog Talk Sent: Friday, August 23, 2002 10:35 AM Subject: Odd search results, or odd programmer, not sure which... > 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/
Inkblot Media
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:
Database Options (1997)
The Guru, The Mooseman, Susie and Is That Really the Only Manual? (1998)
WebDNA Quick Reference (Reserved Words) (2000)
How do I handle extra spaces? (2002)
Questions To Answer (1997)
[WebDNA] remove preceding zero (2016)
Running _every_ page through WebCat ? (1997)
WCf2 and nested tags (1997)
Multiple security dbs (1997)
WebCat for Unix?? (1997)
Processing all html files through WebCat or Typhoon (1998)
WCf2 and nested tags (1997)
Changes to the List (1997)
Help! WebCat2 bug (1997)
Math Context (2001)
WC2b15 File Corruption (1997)
HTML Mail & Line breaks... (2004)
Adding Header Values with [SetHeader] (1998)
hyperlinking unique input strings on the fly when displayingin HTML (2000)
Running _every_ page through WebCat-error.html (1997)