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

Order not created error (1997) Search in 2 or more catalogs (1997) form data submission gets truncated (1997) WC2b15 File Corruption (1997) all records returned. (1997) [UPPERCASE] (1997) WebCat2b15MacPlugin - [protect] (1997) Location of Browser Info.txt file (1997) [WebDNA] crashing loop - SOLVED (2011) possible, WebCat2.0 and checkboxes-restated (1997) Layers,Dreamweaver and WebCat Code (2000) Change Subtotal (2000) DON'T use old cart file! (1997) BIG PROBLEMS with Checkboxes!!! (1998) creator code (1997) WebDNA v6.0 (2004) Associative lookup style? + bit more (1997) [WebDNA] Decode Base64 Image (2019) WebCat2 - [format thousands] (1997) Finding max value for a field (1997)