(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:

problems with 2 tags (1997) X etc.... (1999) CSV import suggestions (2007) ListWords passing multi values in one form field (2000) Smith Micro - no competition (2000) Pgp&emailer (1997) Temporary Serial Numbers for the Beta (2000) cart converting to scientific notation format (2001) [WebDNA] OT: 2 php/MySQL & 1 Flash person needed FT (2008) Database Sizes (2000) Using Applescript to process WebCatalog functions (1998) shipCost formula (1997) [addlineitems] as oppossed to url command=add (2000) Does not begin with.... (2003) same products but different (1998) Browser frames and URLs in the Location field (2004) WebCatalog2 Feature Feedback (1996) uploads (2000) Users and groups for local directories (1999) one item in several different categories? (2000)