Re: Question about searching combination of fields

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48755
interpreted = N
texte = You only have one data term in your search - eqprodlinedata. You are not testing the Subject or Category1 fields, though you are summarizing the Subject field, so will only get one record for each found Subject value. When you do add the additional terms, you'll either want to add an allreqd=T term or add rq to all the data terms. I don't know exactly what you are looking for, but it's probably something like this (with no line breaks):[search db=inventory.db&eqprodlinedatarq=[url][prodline][/ url]&eqsubjectdatarq=[url][subject][/ url]&eqcategory1datarq=[url][catgory1][/url] &subjectsumm=t&assubjectsort=1]- though looking for only one subject value and summarizing on the subject so you only get one record for that subject is a rather odd combination that probably doesn't meet your goal. You probably want to take out the subjectsumm=t term.- brianOn Monday, March 17, 2003, at 10:29 PM, Steve Chun wrote:> I can't seem to get a handle on this simple concept. Trying to create > a search that will return results based on all three criteria > matching: > > 1) Subject > 2) Prodline > 3) Category1 > > [search > db=inventory.db&eqprodlinedata=[prodline]&subjectsumm=t&assubjectsort=1 > ] > > > [foundItems] > > href=thumbs.html?cart=[cart]&cust=[cust]&subject=[url][subject][/ > url]&prodline=[url][prodline][/url]&category1=[category1]>[subject] a> > [/foundItems] > [/search] > > > As it is, this search is returning results based on any of the > criteria matching. Do I need the reqd=T tag somewhere? > > Thanks. > > > sc > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Question about searching combination of fields (Kenneth Grome 2003)
  2. (More) Re: Question about searching combination of fields (Charles Kline 2003)
  3. Re: Question about searching combination of fields (Brian Fries 2003)
  4. Re: Question about searching combination of fields (Glenn Busbin 2003)
  5. Re: Question about searching combination of fields (Charles Kline 2003)
  6. Question about searching combination of fields (Steve Chun 2003)
You only have one data term in your search - eqprodlinedata. You are not testing the Subject or Category1 fields, though you are summarizing the Subject field, so will only get one record for each found Subject value. When you do add the additional terms, you'll either want to add an allreqd=T term or add rq to all the data terms. I don't know exactly what you are looking for, but it's probably something like this (with no line breaks):[search db=inventory.db&eqprodlinedatarq=[url][prodline][/ url]&eqsubjectdatarq=[url][subject][/ url]&eqcategory1datarq=[url][catgory1][/url] &subjectsumm=t&assubjectsort=1]- though looking for only one subject value and summarizing on the subject so you only get one record for that subject is a rather odd combination that probably doesn't meet your goal. You probably want to take out the subjectsumm=t term.- brianOn Monday, March 17, 2003, at 10:29 PM, Steve Chun wrote:> I can't seem to get a handle on this simple concept. Trying to create > a search that will return results based on all three criteria > matching: > > 1) Subject > 2) Prodline > 3) Category1 > > [search > db=inventory.db&eqprodlinedata=[prodline]&subjectsumm=t&assubjectsort=1 > ] > > > [founditems] > > href=thumbs.html?cart=[cart]&cust=[cust]&subject=[url][subject][/ > url]&prodline=[url][prodline][/url]&category1=[category1]>[subject] a> > [/foundItems] > [/search] > > > As it is, this search is returning results based on any of the > criteria matching. Do I need the reqd=T tag somewhere? > > Thanks. > > > sc > > > ------------------------------------------------------------- > 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://webdna.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://webdna.smithmicro.com/ Brian Fries

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:

Searching multiple Databases (1997) Any way to retrieve information from clipboard? (1998) Emailer help....! (1997) Not really WebCat (1997) [WebDNA] [WSC] WebDNA Development Summit (2014) Cart date/time (2006) Email (1998) America Online Issues (1998) CC verification (2001) Product Comparison (2000) One more try (1997) Installation webCatalog (French speakers please help) (1998) TCP Connect (2000) Is this possible, WebCat2.0 and checkboxes (1997) nesting limits? (1998) WebCat2: multiple currency support (1997) Email (1998) Tab Charactor (1997) WCS Newbie question (1997) WC1.6 to WC2 date formatting (1997)