Re: Combining search criteria

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 31851
interpreted = N
texte = Firstly if you are really searching the same field twice then you need to use group searching, but if they are different fields or you do use the group method then you need to ad the rq to second search param.That way you will find any of the Firecracker,Flag,Memorial only if they contain red,white and blu.Is this what you are trying to achieve?Paul Fowler> From: Wilkins, John > Reply-To: (WebCatalog Talk) > Date: Sun, 14 May 2000 13:13:44 > To: (WebCatalog Talk) > Subject: Re: Combining search criteria > > Thanks for the help, but I probably did not explain my needs properly. > between the two criteria listed below I want an or condition, so that's > why I'm not using the rq after each one. The problem I'm having is that I > can't get the second criteria listed below to work properly. The red, > white, and blue criteria is coming out as red or white or blue, even though > I'm using wa. Is it because of the wo criteria used, in the first > criteria? > > &woDescriptiondata=Firecracker,Flag,Memorial&waDescriptiondata=red,white,blu > e > > > woDESCRIPTIONdatarq&waDESCRIPTIONdatarq > -----Original Message----- > From: Brian Boegershausen [mailto:brianboegs@collegefever.com] > Sent: Sunday, May 14, 2000 11:28 AM > To: WebDNA-Talk@talk.smithmicro.com > Subject: Re: Combining search criteria > > > woDESCRIPTIONdatarq > waDESCRIPTIONdatarq > using rq in the criteria will require both to be true in the results. > > ----- Original Message ----- > From: Wilkins, John > To: WebCatalog Talk > Sent: Sunday, May 14, 2000 8:10 AM > Subject: Combining search criteria > > >> I need to combine some search criteria into one search so that either of > the >> following will find the needed items: >> >> &woDescriptiondata=Firecracker,Flag,Memorial >> >> &waDescriptiondata=red,white,blue >> >> Notice that the first uses wo and the second wa >> >> When I use both of these in one SEARCH context, I find that the second >> criteria produces results if Description equals red or white or blue, >> however I need it to be red and white and blue. >> >> How can I get the first criteria above to work with or and the second >> criteria to work with and in the same SEARCH context. >> >> ******************************************* >> John R. Wilkins >> Delaware Valley Wholesale Florist >> 520 N. Mantua Boulevard >> Sewell, NJ 08080 >> email: jwilkins@dvwf.com >> fax: 856-415-8920 >> voice: 856-464-2774 >> web: http://www.dvwf.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/ > > ------------------------------------------------------------- > 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: Combining search criteria (Kenneth Grome 2000)
  2. Re: Combining search criteria (John Butler 2000)
  3. Re: Combining search criteria (Wilkins, John 2000)
  4. Re: Combining search criteria (Paul Fowler 2000)
  5. Re: Combining search criteria (Wilkins, John 2000)
  6. Re: Combining search criteria (Brian Boegershausen 2000)
  7. Combining search criteria (Wilkins, John 2000)
  8. Re: Combining search criteria in a context? (Steve Rosenbaum 1998)
  9. Re: Combining search criteria in a context? (Martin Gertz Bech 1998)
  10. Re: Combining search criteria in a context? (PCS Technical Support 1998)
  11. Combining search criteria in a context? (Steve Rosenbaum 1998)
Firstly if you are really searching the same field twice then you need to use group searching, but if they are different fields or you do use the group method then you need to ad the rq to second search param.That way you will find any of the Firecracker,Flag,Memorial only if they contain red,white and blu.Is this what you are trying to achieve?Paul Fowler> From: Wilkins, John > Reply-To: (WebCatalog Talk) > Date: Sun, 14 May 2000 13:13:44 > To: (WebCatalog Talk) > Subject: Re: Combining search criteria > > Thanks for the help, but I probably did not explain my needs properly. > between the two criteria listed below I want an or condition, so that's > why I'm not using the rq after each one. The problem I'm having is that I > can't get the second criteria listed below to work properly. The red, > white, and blue criteria is coming out as red or white or blue, even though > I'm using wa. Is it because of the wo criteria used, in the first > criteria? > > &woDescriptiondata=Firecracker,Flag,Memorial&waDescriptiondata=red,white,blu > e > > > woDESCRIPTIONdatarq&waDESCRIPTIONdatarq > -----Original Message----- > From: Brian Boegershausen [mailto:brianboegs@collegefever.com] > Sent: Sunday, May 14, 2000 11:28 AM > To: WebDNA-Talk@talk.smithmicro.com > Subject: Re: Combining search criteria > > > woDESCRIPTIONdatarq > waDESCRIPTIONdatarq > using rq in the criteria will require both to be true in the results. > > ----- Original Message ----- > From: Wilkins, John > To: WebCatalog Talk > Sent: Sunday, May 14, 2000 8:10 AM > Subject: Combining search criteria > > >> I need to combine some search criteria into one search so that either of > the >> following will find the needed items: >> >> &woDescriptiondata=Firecracker,Flag,Memorial >> >> &waDescriptiondata=red,white,blue >> >> Notice that the first uses wo and the second wa >> >> When I use both of these in one SEARCH context, I find that the second >> criteria produces results if Description equals red or white or blue, >> however I need it to be red and white and blue. >> >> How can I get the first criteria above to work with or and the second >> criteria to work with and in the same SEARCH context. >> >> ******************************************* >> John R. Wilkins >> Delaware Valley Wholesale Florist >> 520 N. Mantua Boulevard >> Sewell, NJ 08080 >> email: jwilkins@dvwf.com >> fax: 856-415-8920 >> voice: 856-464-2774 >> web: http://www.dvwf.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/ > > ------------------------------------------------------------- > 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/ Paul Fowler

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:

AppleScript error (2003) No. of items in shopping cart (2000) RE: Symantec VIsual Page 1.0.3 (1997) I can help! (1996) v5.x and Apache 2.x (2003) Looking For WebCatalog Migration Assistance (2003) RE: [shownext] support - MacOS (1997) WebCat2final1 crashes (1997) Input and Convertchars contexts (2003) PCS Frames (1997) Bug Report, maybe (1997) Firesite cache vs webcat cache (1997) [searchString] (1997) Forms Search Questions (1997) Text limits in NT version? (1997) WebCatalog/WebMerchant 2.1 (1998) question: webmerchant connection (1997) Bug Report, maybe (1997) [WebDNA] Variable mystery (2009) [ModDate] & [ModTime] ? (1997)