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

This WebDNA talk-list message is from

2002


It keeps the original formatting.
numero = 42871
interpreted = N
texte = that should have been 'or' the IF not of. Sorry! ----- Original Message ----- From: Inkblot Media To: WebCatalog Talk Sent: Friday, August 23, 2002 11:25 AM Subject: Re: Odd search results, or odd programmer, not sure which... > 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/ ------------------------------------------------------------- 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)
that should have been 'or' the IF not of. Sorry! ----- Original Message ----- From: Inkblot Media To: WebCatalog Talk Sent: Friday, August 23, 2002 11:25 AM Subject: Re: Odd search results, or odd programmer, not sure which... > 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/ ------------------------------------------------------------- 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:

PCS Frames-Default page is solution! (1997) Error:Too many nested [xxx] contexts (1997) $Replace with [founditems] (1997) ReplaceFoundItems (2006) Data Type Search Problem (2004) Another option (2005) Simultaneous Users (1999) WebDNA-Talk Digest mode broken (1997) Variable prices and Formulas.db (1997) service stop and restart (1997) FREE Web Server Monitor FREE (1997) Dealer locator (1998) talking to MacAuthorize (1997) DataBaseHelper Flawed (1997) form validator issue (2005) searchable list archive (1997) Implementing Gift Certificates in online store (1998) Cookies (2001) Wanted: Broader string manipulation functions (1997) Use of & in text areas.... (1998)