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:

[WebDNA] Bug reporting (2009) [WebDNA] WebDNA not parsing php files (2012) Shopping carts and reloading pages (1997) [WebDNA] [OT] potential cheap WebDNA server? (2009) TRAINING videos - Prove IT. (1998) Error with [applescript] (1999) database paths/names, and a typo (1997) MasterCounter Weirdness (1997) problems with 2 tags (1997) Where is f2? (1997) Error Lob.db records error message not name (1997) HTML email (2004) Menu Syntax on Edit/Add templates (1998) RE: protect tag on NT (1997) Limiting user access to .tmpl files (1997) search comparison (2003) Sorting... stumped. (2006) [SHOWIF AND/OR] (1997) politeness (was searches with dash...) (2000) Wanted: More Math Functions (or, Can You Solve This?) (1997)