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

Delete context run amok (2005) SKU (1997) text size limitation (1997) AOL and webcat (1998) HEADER AND FOOTER (1997) More on the email templates (1997) Strange Search Results (2004) Add htmlarea 3 to SiteBuilder (2004) Been meaning to ask... (1997) Cant get my own subtotal (2001) How to download a database???/ (2000) Saving [referrer] for later use (1997) Mass-mailer options - any suggestions ? (2005) Gold on the list ... Was Authorize.net? (2003) [UPPERCASE] (1997) shipCost (1998) Secure server question (1997) Some Questions (1997) Intermitent problem using [referrer] (1997) [WebDNA] seconds_to_time (2017)