(More) Re: Question about searching combination of fields

This WebDNA talk-list message is from

2003


It keeps the original formatting.
numero = 48756
interpreted = N
texte = On Tuesday, March 18, 2003, at 01:29 AM, 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. >The ONLY comparison you are making in the query is that PRODLINE is equal to the value you pass in the variable [prodline]. The others items in your query are just summarizing/sorting the returned data from the query. (Maybe you know that?)- Charles ------------------------------------------------------------- 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:

    
On Tuesday, March 18, 2003, at 01:29 AM, 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. >The ONLY comparison you are making in the query is that PRODLINE is equal to the value you pass in the variable [prodline]. The others items in your query are just summarizing/sorting the returned data from the query. (Maybe you know that?)- Charles ------------------------------------------------------------- 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/ Charles Kline

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:

Nested tags count question (1997) quitting (1997) FW: Information Regarding Recent Payment Gateway SystemDifficult (2002) [WebDNA] 6.2.1 fails on Apache 2.4.6 (2014) encryption in browser? (1998) Questions (1998) WebCatalog2 for NT Beta Request (1997) Request for page test (2003) WebCat2b15MacPlugin - [protect] (1997) Max Record length restated as maybe bug (1997) writefile and texte (1997) OT - New Ti Books (2002) [ShowNext] (1997) WebCat2 beta FTP site (1997) It gets better... posting problems + Webcat 3.0.7 available - did anyone know? (2000) OT : Firewall for webserver (2006) Quick Question About Sorting (1997) Null Chars (1999) Searchable WebCat (etc.) Docs ? (1997) Writefile problem (1999)