Re: Question about searching combination of fields

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48754
interpreted = N
texte = >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]Try this:[search db=inventory.db&subjectdatarq=[subject]&eqprodlinedatarq=[prodline]&eqcategorydatarq=[category]&subjectsumm=t&assubjectsort=1]> > >[foundItems] > >[subject] >[/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? >It looks like it would return results based on only the Prodline criteria. No other was included in the search.Glenn------------------------------------------------------------- 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)
>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]Try this:[search db=inventory.db&subjectdatarq=[subject]&eqprodlinedatarq=[prodline]&eqcategorydatarq=[category]&subjectsumm=t&assubjectsort=1]> > >[founditems] > >[cart]&cust=[cust]&subject=[url][subject][/ url]&prodline=[url][prodline][/url]&category1=[category1]>[subject] >[/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? >It looks like it would return results based on only the Prodline criteria. No other was included in the search.Glenn------------------------------------------------------------- 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/ Glenn Busbin

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:

One tough Cookie (1998) Cancel Subscription (1996) WebCat and image maps (1997) ShowNext - This is Killing me! (1998) Creating 404 Not Found pages (1999) [Sum] function? (1997) [CART] inside a [LOOP] (1997) select menus & database design (1998) [showif] not working (2003) 3.0 [TEXT] variables (1998) Globals folders (2004) RE: [redirect] w/o showing args? (1999) ODBC problems between webcat and filemaker pro (2001) WebDNA and SQL (2003) multi-paragraph fields (1997) [REFERRER] works with form posts (2003) Deleting Orders (1997) Grep Again (was: MySQL UPDATE) (2007) Loosing Quantity (2000) A little help on e-mail (HELP!!! :-) ) (1998)