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:
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:
Emailer (WebCat2) (1997)
PIXO Support (1997)
CSS problem (2000)
WebCatalog/Mac 2.1b2 New Features (1997)
update on wn searching (1997)
Lots of bounce errors (2007)
SiteEdit Pro Update Announcement (1997)
WebCatalog for guestbook ? (1997)
Re1000001: Setting up shop (1997)
Card clearance, problems - solutions? (1997)
no global [username] or [password] displayed ... (1997)
The List is Changing (1997)
Add a field to the error log? (1997)
Providing hard copy of database to client (1997)
Thanks ! (1997)
WebDNA Solutions ... sorry! (1997)
Re:PCS Customer submissions ? (1997)
Sort Order on a page search (1997)
Another question about credit cards (1997)
Setting up the server (1997)