Re: Combining search criteria
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 31852
interpreted = N
texte = What I'm trying to achieve is any of the Firecracker,Flag,Memorial items, or any item that's red and white and blue. The field being searched Description, is the same for both. -----Original Message----- From: Paul Fowler [mailto:paul@zgtec.com] Sent: Sunday, May 14, 2000 1:54 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: Combining search criteria 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/------------------------------------------------------------- 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:
What I'm trying to achieve is any of the Firecracker,Flag,Memorial items, or any item that's red and white and blue. The field being searched Description, is the same for both. -----Original Message----- From: Paul Fowler [mailto:paul@zgtec.com] Sent: Sunday, May 14, 2000 1:54 PM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: Combining search criteria 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/------------------------------------------------------------- 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/
Wilkins, John
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:
Cart date/time (2006)
Grouping search fields, etc. (1997)
[delete] problem (1997)
I found a bug ... (1997)
Same DB Same Time (2004)
Emailer on NT! (1998)
[platform] tag? (1998)
Deleting with contexts (2001)
Plugin or CGI or both (1997)
sorting... (2003)
Irc (2000)
problems with 2 tags (1997)
XML Syntax, Cookies and Variables.... (2004)
New Cart No. on same page (2003)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Multiple fields on 1 input (1997)
Trigger: Only on Saturday (2001)
Solution help needed (1998)
RE: extended ASCII with middle command (1999)
[HIDEIF] inside [FOUNDITEM] (1997)